Rolling 12 month average using Month_Year Format in the axis

[kamalbandam]

Hello Everyone,

I have Rolling 12 month average calculated using Quick measure. It is working well and fine. When I try to use the Rolling 12 avg in a bar chart using Month_Year Format i.e Jan-20 in the axis it is giving me a blank value. The Month_Year format is from the same date table.

Any help would be grateful.

Thanks in Advance

[amitchandak]

@kamalbandam , if date table is marked as date table and rolling is using date table and month year is from date table, it should work.

example

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