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

Anonymous's avatar
Anonymous
Not applicable
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