Forum Discussion

Qualube's avatar
Qualube
Icon for Helper II rankHelper II
7 years ago
Solved

Running Comparion to previous year

Hi   I need to establish the comparative volumes from the previous year against the current year. I think I am part way there but can't finalise the measure to achieve this.     I know I need to...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Qualube,

     

    Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

The SUMX is not required.  Try these measures:

 

RT_Volume = SUM(SALESLINE[NEW VOLUME])

PY RUNNING TOTAL = CALCULATE([RT VOLUME],SAMEPERIODLASTYEAR('DATE'[Date]))

 

There should be a relationship from the Date column of the Salesline Table to the Date column of the Date Table.

 

Hope this helps.

Qualube's avatar
Qualube
Icon for Helper II rankHelper II
7 years ago

Hi Ashish

 

Thanks for the reply but just a question before I go ahead.

If I use RT_Volume = SUM(SALESLINE[NEW VOLUME]) will that not add all the volumes and not just the ones for this financial year?

Don't I need this filter so I don't return all volumes since the very first delivery date?