Forum Discussion
previous date filter
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?
2 Replies
Anonymous , 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-5c3243d1f9example
Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))
