Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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()
)
Proud to be a Super User! | |
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()
)
Proud to be a Super User! | |
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |