Forum Discussion
Irregular Behaviour DAX
Hello, I am using the DAX to filter a valid date which is greater than today's date. I see it misbehaving in the following example I am using the DAX below, IsValidNow = VAR VALID_TO = FO...
Think the issue here is when you format the date it changes the data type to text. There's no need to format it though, you can just use
Column = if( Table2[Valid To] >= Now(), "Yes", "No")