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 Discount as a Percentage] else null
END
Any help would be great!
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()
)
1 Reply
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()
)