Forum Discussion

NickProp28's avatar
NickProp28
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Calculate Cumulative by year

Dear Community,    Good Day. Please have a look on this pbix: https://ufile.io/5uxflmsc In this pbix, i have the data for 2 year and comparing to the particular month when month slicer is s...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi NickProp28 ,

     

    Crreste the following measure:

    Consol= TOTALYTD( count(ConsolShipment[Consol ID]);'Calendar'[Date])

     

    Now you just need to do the same measure for the rest of the columns you need:

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi NickProp28 ,

 

Crreste the following measure:

Consol= TOTALYTD( count(ConsolShipment[Consol ID]);'Calendar'[Date])

 

Now you just need to do the same measure for the rest of the columns you need: