Subtract Values Row by Row with EARLIER function

[Anonymous]

Dear Contributors, 

Please help me to adjust the Calculated Column formula, so that the outcome was the same as the Measure.

Note, that for Calculated Column a Base value (Resources Needs) is not summarized by date, opposed to the Measure.

Difference Column = 'Resources Needs'[Resources Needs]-CALCULATE(MAX('Resources Needs'[Resources Needs]);FILTER('Resources Needs';'Resources Needs'[Project]=EARLIER('Resources Needs'[Project])&&'Resources Needs'[Position]=EARLIER('Resources Needs'[Position])&&'Resources Needs'[Recruitment Status]=EARLIER('Resources Needs'[Recruitment Status])&&'Resources Needs'[Date]<EARLIER('Resources Needs'[Date])))

 

Difference Measure = SUM('Resources Needs'[Resources Needs])-CALCULATE(SUM('Resources Needs'[Resources Needs]);PARALLELPERIOD('Resources Needs'[Date];-1;MONTH))

Pbix file is available here

Best regards,

Anna

[Anonymous · Accepted solution]

I doubt that MIN, as well as MAX is correct for my case:

Basically I need (Sum [Resources Needs] within a Month)  - (Sum [Resources Needs] within a Previous Month), but in this case how to deal with the result:

  

[Greg_Deckler]

What happens if you substitute MIN for MAX in your column formula?

[Anonymous · Accepted solution]

I doubt that MIN, as well as MAX is correct for my case:

Basically I need (Sum [Resources Needs] within a Month)  - (Sum [Resources Needs] within a Previous Month), but in this case how to deal with the result:

  

[Greg_Deckler · Accepted solution]

I guess where I was going with that is that you appear to have multiple matching rows so you either need to have better filters or you are going to need a different aggregation like AVERAGE or something.