0 votes
2 views
in BI

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!

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer