Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (2.6k points)

I am trying to calculate a 6-month rolling sum of the 'Booked' column pictured below. I am still learning Power BI and can't seem to figure out a way to do this. Basically, the perfect solution would create another column where each month had a total for the previous 6 months of booked dollars.

1 Answer

0 votes
by (7.2k points)
edited by

To get Power BI Rolling 6 Month Sum...

For your understanding, I’ll take the table name as "Sales".

First, you need to create several base measures:

[Total Booked Sales]:= SUM(Sales[Booked]) [Period

 End]:=LASTDATE('Sales'[Date]) [Period Start]:= FIRSTDATE(

 DATESINPERIOD('Sales'[Date], [Period End], -6, MONTH))

After that you need to calculate rolling 6-months sales:

Sales 6 Months:=CALCULATE( [Total Booked Sales],

DATESBETWEEN ( 'Sales'[Date], [Period Start], [Period End] ))

Want to earn a certificate in Power BI? here is the Power BI Course that will make you industry ready! 

Related questions

0 votes
1 answer
asked Dec 1, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
asked Mar 4, 2021 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...