Recent sale - sale before any date (growth rate)

[Anonymous]

Good morning/ evening everyone.

I'm am trying to calculate the difference between sales im time.

I have done my calcualtions with.

MarginYTD = TOTALYTD([Margin Real+];'Calendar'[Date])

and

MarginMTD = TOTALMTD([Margin Real+];'Calendar'[Date])

The numbers next to the names from the same table. This is just a fragment of the table.

However what I want to do now is to calculate the most recent up to date sale which could be for example today or yesterday (most recent one - like in the picture) and MINUS one sale before that (doesnt matter which date e.g. it could be in 2017 or 2016) just for multiple products one sale before. + difference rate.

How should I write up my formula?



Thank you for your time.

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may refer to the DAX in link below.

http://community.powerbi.com/t5/Desktop/Finding-the-previos-occurrence-within-same-table-based-on-one/m-p/342607

[Anonymous]

Thank you for your time and efforts.