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
did you try by setting the aggregation to MAX on your sale amount column and filter the analysis on the last 3 months?