Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Help with showing difference between rows in matrix report

Hi,

I need help to show the difference for each column between every periods.

Currently I have:

 

My desired report is like (I do this in Excel)

 

Any help is much appreciated.

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi Anonymous,

     

    If you have a proper calendar table and a relationship form the date column of your data table to the date column of your calendar table, then the PREVIOUSMONTH() function should work.

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks for the suggestion. 

      Just want to clarify, those values shown are measuered values and the column headings just the category name, nothing to do with the date.

       

      Units =
      VAR CurrentMth = max(Table1[Period])
      Return
      calculate(DISTINCTCOUNT(Table1[Serial #]),Table[Period]=CurrentMth)

       

      So, I don't have a field reference to put into 

      =CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), PARALLELPERIOD(DateTime[DateKey],-1,year))

       Please advise.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi Anonymous,

     

    If you have a proper calendar table and a relationship form the date column of your data table to the date column of your calendar table, then the PREVIOUSMONTH() function should work.