Power bi report builder chart sum several periods

[larssae]

Hello! 

I'm currently tryng out the Power Bi Report builder where I'm stuck. 

On the right y axis I have the sum of the revenue, basically =Sum(Fields!FIeld1.Value). Category is time. 

However, on the left I want to to have sum of the twelve last months but I don't know how to write the formula, does anyone have any suggestion if it is possible? 

As an exemaple, time C is the revenue for Month X in the right Y axis (that I have) and left is the cumulative revenue of the 12 past months. I have monthly data. 

[amitchandak · Accepted solution]

@larssae , In DAx we can create measure like this

Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))

[larssae]

@amitchandak Thanks for reaching out and sorry for me being unclear. I don't think it is possible to use DAX measures in Power BI Report Builder? 

Are you aware if there is another support forum for questions related to Power BI Report Builder?