Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.
Here is the formula and table:
Solved! Go to Solution.
Your Date column is in Text format not Date format. Select Date column - And choose Data type as Date.
Then your formula would work
Thank you so much, it worked
Your Date column is in Text format not Date format. Select Date column - And choose Data type as Date.
Then your formula would work