Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Doing Pivot Table calculations on raw data

I have a bunch of raw, unpivoted data over 20Years for franchise locations around the US. I want to look at YTD member conversions (from one membership package to another) for each franchise location...
Need Help
v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

 

You might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-diye-msft ,

     

    Thanks for the response.


    Essentially, I want to do pivot table type calculations on raw data without needing to pivot the data.  Below is an example of what the data looks like when put into a matrix form. Essentially, all I want to do is create calculations/columns/measures that subtract the total number of conversions in each fiscal year by each franchise to get the YoY difference at each location.  

     

    So for example, the expected result for this type of calculation would be the franchise specific YTD sales minus the YTD sales from last year.  Again, I'm able to do this for all franchises grouped together, but not ona franchise specific basis.

     

    Does this help? I just need a calculation likely with a filter, to get this but I can't figure it out.  

     

    Michael

    • v-diye-msft's avatar
      v-diye-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous 

       

      Please kindly share the data in the table rather than Matrix, and disclose the expected results. that would be easier for us to repro the scenario and provide a valuable solution. looking forward to your reply.