Previous date

[Vishal_2202]

I want to create a custom column for previous date of sys date (sys date -1)

[Anonymous · Accepted solution]

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()-1

TODAY function (DAX) - DAX | Microsoft Learn

Regards,

Xiaoxin Sheng

[Vishal_2202]

There is a last_run_date column which contains date and want to compare it with sys_date -1

[FreemanZ]

hi @Vishal_2202 

what is sys_date? a column, a measure?

p.s. please consider @someone, if you seek further sugestions. 

[FreemanZ]

hi @Vishal_2202 

could you provide some sample data?