How to calculate previous month ignoring other selection

[anindya_manna]

I am calculating previous month date(AddMonths(date#(max([Months Number]),'YYYYMM'),-1),'YYYYMM') by using this formula for calculating previous month sales.

But when I am choosing any Rep id then the previous month calculation is going changed as per the rep id selection.

How to keep it fixed? Means I want the previous month is always max(month number)-1 irrespective of any selection.

[jmvilaplanap]

Hi

You must to use SetAnalysis, for example:

date(AddMonths(date#(max({1}[Months Number]),'YYYYMM'),-1),'YYYYMM')

[agigliotti]

maybe this:

date(AddMonths(date#(max( {1} [Months Number]),'YYYYMM'),-1),'YYYYMM')

[anindya_manna]

I want to date selection will change the calculation but not rep id or product name field.

if I choose  05/05/2017 then prev moth should be 201704.Date filter should work but not other filter effect the result.

[anindya_manna]

I want to date selection will change the calculation but not rep id or product name field.

if I choose  05/05/2017 then prev moth should be 201704.Date filter should work but not other filter effect the result.

[anindya_manna]

I want to date selection will change the calculation but not rep id or product name field.

if I choose  05/05/2017 then prev moth should be 201704.Date filter should work but not other filter effect the result.

[jmvilaplanap]

Then use the date field inside the set analysis

But can you share an example of the expression you need? (without the set analysis)

[agigliotti]

let's try with below:

date(AddMonths(date#(max( {<1 [Months Number] = ::$[Months Number] >} [Months Number]),'YYYYMM'),-1),'YYYYMM')

[anindya_manna · Accepted solution]

=date(AddMonths(date#(max( {1< [FSPM Month Number] = $::[FSPM Month Number]>}  [FSPM Month Number]),'YYYYMM'),-1),'YYYYMM')