Creating a Measure: Max Sale Amount from Last Three Months

Question

Hi All,

I have a sales table, Now I need to create report like below Columns

Month Name, Sale Amount, Max sale amount from last three months

Please suggest how can I Create measure for Max sale amount from last three months

Thanks in Adavance

Gianni Ceresa · Answer

Hi,

did you try by setting the aggregation to MAX on your sale amount column and filter the analysis on the last 3 months?