Forum Discussion

Avermaak's avatar
Avermaak
Icon for Helper I rankHelper I
4 years ago
Solved

DAX comparison operations do not support comparing values of type Text with values of type Integer

Good day,   I am having some trouble with a formula, I am trying to add the fiscal year as a column but get this error:  *DAX comparison operations do not support comparing values of type Text wit...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Your Date column is in Text format not Date format. Select Date column - And choose Data type as Date.

    Then your formula would work

Avermaak's avatar
Avermaak
Icon for Helper I rankHelper I
4 years ago

Thank you so much, it worked