Creating a Measure: Max Sale Amount from Last Three Months

1008490

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

Hi,

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