Forum Discussion
Solved
Formula Error Using Date Variables - DAX error does not make sense to me
Hello all, I am trying to create a flag of 1 or 0 based on the timing of 2 date columns in my table, but I am getting the error message "DAX comparison does not support comparing values of type ...
hi colettb
The error happens because a single ampersand (&) is used for joining text strings (concatenation). Power BI is trying to concatenate a string with a date comparison, causing a type conflict.
To fix this, you need to make two changes:
- Use the double ampersand (&&), which is the logical AND operator for combining conditions.
- To check if the date is not null, wrap your ISBLANK() check in the NOT() function.
Flag =
IF(
NOT(ISBLANK('Metrics'[Date1])) && 'Metrics'[Date2] < (TODAY() - 60),
1,
0
)
Thank you Cookistador! That worked, I was totally looking at the wrong part of the formula.