Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

PY MTD Cumulative value

Hi all,   I have a table full of sales data for 2018 & 2017. I can happily show the value for PY, however I want to show this as a cumulative figure in a graph by month. As in my month starts at ze...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous 

    For PY MTD , you could just use this simple formula:

    MTDCU = Calculate(sum('salesdata'[dailyfigure]), DATESMTD('date'[Date]))

    PY = Calculate( [MTDCU] , SAMPEPERIODLASTYEAR('date'[Date]))

     

    If not your case, please share your sample data and expected output.

     

    Best Regards,
    Lin

     

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

HI, Anonymous 

For PY MTD , you could just use this simple formula:

MTDCU = Calculate(sum('salesdata'[dailyfigure]), DATESMTD('date'[Date]))

PY = Calculate( [MTDCU] , SAMPEPERIODLASTYEAR('date'[Date]))

 

If not your case, please share your sample data and expected output.

 

Best Regards,
Lin

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for your help. I think I went snow blind yesterday looking at data. Makes perfect sense. 

 

Thank you.