Forum Discussion

Jorgast's avatar
Jorgast
Icon for Resolver II rankResolver II
6 years ago
Solved

Median %

Hello BI Team   I am trying to determine the Median % change based on the previous 12 months.     The problem I am running into is all my data comparison points are measures and Median uses colu...
Need Help
  • Jorgast's avatar
    Jorgast
    6 years ago

    Now that I have everything as a column in my Summary table. I think this might work for me.

    Median = CALCULATE(MEDIAN(TEST[% Change]), DATESINPERIOD(TEST[MMM_YYYY],PREVIOUSMONTH(ZZTEST[MMM_YYYY]), -12, MONTH)).
    Will this get me a rolling 12 months of Medians?
     
Jorgast's avatar
Jorgast
Icon for Resolver II rankResolver II
6 years ago

Now that I have everything as a column in my Summary table. I think this might work for me.

Median = CALCULATE(MEDIAN(TEST[% Change]), DATESINPERIOD(TEST[MMM_YYYY],PREVIOUSMONTH(ZZTEST[MMM_YYYY]), -12, MONTH)).
Will this get me a rolling 12 months of Medians?
 
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Actually you need to test that