Cumulative month on Month data

[vjnvinod]

@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

[v-xuding-msft]

Hi @vjnvinod ,

Maybe you could pin the entire page to a dashboard. In this way, the dashboard can contain slicers and then the clients can filter data in it.

Reference:

Pin an entire report page, as a live tile, to a Power BI dashboard 

[AnkitBI]

Hi @vjnvinod

It may be possible but we will require some sample data for 2-3 months to suggest.

[amitchandak · Accepted solution]

@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]

@amitchandak

It doesn't really work that way.

[vjnvinod]

@amitchandak 

Actually not working that way