Forum Discussion
Previous date
I want to create a custom column for previous date of sys date (sys date -1)
Hi Vishal_2202,
I'd like to suggest you use today function to create a calculated column show the previous date of running system date. (the result will change when system date changes)
PreviousDate = TODAY()-1TODAY function (DAX) - DAX | Microsoft Learn
Regards,
Xiaoxin Sheng
4 Replies
hi Vishal_2202
could you provide some sample data?
There is a last_run_date column which contains date and want to compare it with sys_date -1
hi Vishal_2202
what is sys_date? a column, a measure?
p.s. please consider @someone, if you seek further sugestions.
Hi Vishal_2202,
I'd like to suggest you use today function to create a calculated column show the previous date of running system date. (the result will change when system date changes)
PreviousDate = TODAY()-1TODAY function (DAX) - DAX | Microsoft Learn
Regards,
Xiaoxin Sheng
