Forum Discussion

Vishal_2202's avatar
Vishal_2202
Frequent Visitor
3 years ago
Solved

Previous date

I want to create a custom column for previous date of sys date (sys date -1)
"DAX" "Earliest date"
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
Vishal_2202
Frequent Visitor
3 years ago

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

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi Vishal_2202 

     

    what is sys_date? a column, a measure?

     

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