Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

Cumulative month on Month data

amitchandak    i have  some revenue data its comes to me on a month on month basis but it will be cumulative dataset   for eg P1, p2=P1+P2 and so on till P12   Currently the power BI dashboard...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 years ago

    vjnvinod ,

     

    Join with Date table, Create during the last ticket. We have rank for the period there.

    Something like


    This period Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all(Date), Date[period Rank]= Max(Date[period Rank])))
    - CALCULATE(SUM(Sales[Sales Amount]),filter(all(Date), Date[period Rank]= Max(Date[period Rank])-1))

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

vjnvinod ,

 

Join with Date table, Create during the last ticket. We have rank for the period there.

Something like


This period Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all(Date), Date[period Rank]= Max(Date[period Rank])))
- CALCULATE(SUM(Sales[Sales Amount]),filter(all(Date), Date[period Rank]= Max(Date[period Rank])-1))

 

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago

@amitchandak

It doesn't really work that way.