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!