Hi All ,
Q1. I've tried but I cant figure out how to solve this error: "DAX comparison operations do not support comparing values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values"
The error comes when I try to do this formula:
NewColumn =
IF ([OutOfDate] > 9, "Red" ,
IF ([OutOfDate] <= 9 && [OutOfDate]>=5 = "Amber", "Green"
))
Im trying to create a column that displays Amber/Red/Green dependping on how high the number is. "NewColumn" is calculating this from 2 other measures I created if thats useful (Last entry and date difference between that days and now)
Wierdly, I have another dashbord with this exact table and it works just fine, so Im confused about the error in this dashbord. Ive checked to make sure everything is the same but no luck!
Q2. In the second dashboard, I have a column that calculates the "NewColumn" just fine, and the outputs are red amber green depending on the location. I want to display this in a bar chart so that theres a bar for 'red', bar for 'green' etc . So far using the bar chart feature, it displays the total of unique value, 3 in this case. Is there a way I can seperate them and display red, green and amber sepereately?
feel free to suggest a better way to do that if statement
