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 i have created is based on Month, every month i will refresh the dataset and it works

now the challenge is after refreshing  my client has to see the previous report, they will have to go the previous links published in service

 

is there a way, i can have one dashboard and client can filter based on Periods(P1, to P12)

Let me know if that something you can help

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))

     

5 Replies