Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Below expression is for calculating previous month.
=date(AddMonths(date#(max([FSPM Month Number]),'YYYYMM'),-1),'YYYYMM')
I want to calculate previous month based on date filter. It should not affected by any other selection like product name and rep id.
Bu using above normal exp. previous month calculation is changing as per selection like product name and rep id
Getting sytanx error
sorry
=date(AddMonths(date#(max( {1< [FSPM Month Number] = $::[FSPM Month Number]>} [FSPM Month Number]),'YYYYMM'),-1),'YYYYMM')
Convert this expression into set expression
Pleas find the attached file here
Thanks.
Its working