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