Forum Discussion
Solved
Create column based on multiple criterias
Hi all, I have a dataset with a following structure. I want to insert a conditional column which would say: if kwh = o and duration > 2, then tell "bad", otherwise "ok" Clients kwh dur...
Hi, taurius2022
Please try formula as below:
Calculated column:
Column = if('Table'[kwh]=0&&'Table'[duration]>2,"bad","ok")Meaure:
Measure = if(MAX('Table'[kwh])=0&&MAX('Table'[duration])>2,"bad","ok")Best Regards,
Community Support Team _ Eason
Calculated column (had this before) : 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. --> #Error
Measure:
I have changed the format of data --> kwh : from text to numers.
Now it works.
Thanks