Tableau to DAX

[g-wizard]

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!

[audreygerred · Accepted solution]

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