Forum Discussion
Solution SageMimic/fake another current date (system date)
Hello,
I have an old'ish data set with the last entries in December 2023. This means that measures like MTD/QTD/YTD etc. are failing since I have no data from the past 3 months? Is there a way to mimic/fake being on the 28th of December (for example)?
PS: I don't want to change the system date that will generate a whole world of other problems
For whomever is interested, I ended up adding a general date slider and dragging the right cursor (or setting up the date) to 31.12.2023. Then all calculations and measures adjusted accordingly (if they were dependent on date one way or another).
3 Replies
- MNedix
For whomever is interested, I ended up adding a general date slider and dragging the right cursor (or setting up the date) to 31.12.2023. Then all calculations and measures adjusted accordingly (if they were dependent on date one way or another).
- Greg_Deckler
Community Champion
MNedix Maybe, are you using a separate date table? Also, what formulas are you using for your MTD/QTD/YTD measures?
- MNedix
Greg_Deckleryes, I use a separate date table which goes from 2020 till Today(). The MTD/QTD/YTD are classical, nothing fancy, e.g. MTD = CALCULATE([Total Amount],DATESMTD('Date'[Date])) (where Total Amount is a measure).
