+ Reply to Thread
Results 1 to 2 of 2

Help needed with fx Measures (Calculated fields) with Power Pivot

  1. #1
    Registered User
    Join Date
    05-08-2018
    Location
    Vancouver, Canada
    MS-Off Ver
    Ofice 2013
    Posts
    26

    Help needed with fx Measures (Calculated fields) with Power Pivot

    Hello,

    I've asked this question a few times but I think I may not have been clear because I haven't received a reply yet. I am trying to create a dashboard for looking how my companies retail stores are performing. We have a lot of data so i decided to use Power Query/Power Pivot. I've gotten as far as being able to build the pivot tables showing this years sales and last years sales. I've done this in 3 different pivot tables to show last week performance, last 4 week performance and season to date performance.

    What I can't do is build the measures/calculated fields to look at the year over year percentage growth for these metrics. Ideally, I'd like to have a an extra field in the pivot table that shows this. I've been stuck on this for a while so any help would be appreciated.

    Since the companies finances are confidential info, I've taken a screen shot of how I have the "dashboard" (just a 1st step) laid out right now with the 3 pivot tables.

    I also attached an example few lines of how the back-end data for last years sales, this years sales, and current inventory for the stores looks like in the data model looks like for reference.

    Thanks for your help!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: Help needed with fx Measures (Calculated fields) with Power Pivot

    I've gotten as far as being able to build the pivot tables showing this years sales and last years sales.
    Perhaps it would help if we could see this type of pivot table produced from the data in the file attached to post #1.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 08-10-2020, 11:38 AM
  2. [SOLVED] Power pivot or pivot table for connecting data and creating calculated fields
    By jaryszek in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 02-06-2019, 08:31 AM
  3. [SOLVED] PowerPivot - problems adding multiple calculated fields (measures)
    By G C in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2017, 11:06 AM
  4. [SOLVED] Pivot calculated fields - dropping needed fields without dropping calculations
    By Aly1978 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-15-2017, 10:25 PM
  5. [SOLVED] trouble with calculated fields in excel for power pivot
    By stephme55 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-29-2016, 02:01 PM
  6. Replies: 2
    Last Post: 10-26-2015, 06:49 AM
  7. Power Pivot - calculated fields
    By Tank13 in forum Excel General
    Replies: 1
    Last Post: 08-27-2014, 12:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1