Forum Discussion
Annualised rolling return - DAX/Calculated Column
" I can see you seem to have got it to report at month end level"
I use the calendar date for the X axis but I have a visual filter set
That way only days that have data are considered for rendering in the visual. The measure still works, even for dates that have no data.
"To confirm - each row in the table you screenshotted in your output has the 'average' of the prior 12/36/60 months of data from the corresponding date point? "
Correct.
" I can see you seem to have got it to report at month end level"
I use the calendar date for the X axis but I have a visual filter set
That way only days that have data are considered for rendering in the visual. The measure still works, even for dates that have no data.
"To confirm - each row in the table you screenshotted in your output has the 'average' of the prior 12/36/60 months of data from the corresponding date point? "
Correct.