previous date filter

[sekka_1985]

Dear all,

i have a report whitch is a snapshot from the system on a weekly base.

so the time stamp is always eavery monday.

colum a: CRD

column b: Snapshot date

I like to compare CRD from latest date with CRD with previous date.

13.03.2023

06.03.2023

27.02.2023

and so on

I like to make a measure that calculate the latest data set with the previous one.

additinal: i like to know how to measure the latest date with the fourth lates.

Could you please support me the the code?

[amitchandak]

@sekka_1985 , try continuous day 

Day Intelligence - Last day, last non continuous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

example

Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))

[sekka_1985]

it works thanks!

Any idea how to code not the previous date but e.g. the fourth last date?