Forum Discussion
Solved
Tableau to DAX
Hellow team, I am trying to convert this calc to dax. I am not familiar with converting the (Today()) function. IF TODAY() <DATE([Validity end date of the condition record]) then [Current D...
Hi! DAX also has a TODAY() function: TODAY function (DAX) - DAX | Microsoft Learn
You can try the below measure: IF(
TODAY() < MAX('Table'[Validity end date of the condition record]),
[Current Discount as a Percentage],
BLANK()
)
audreygerred
Super User
Super UserHi! DAX also has a TODAY() function: TODAY function (DAX) - DAX | Microsoft Learn
You can try the below measure: IF(
TODAY() < MAX('Table'[Validity end date of the condition record]),
[Current Discount as a Percentage],
BLANK()
)