Forum Discussion
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 | duration |
| a | 0 | 0 |
| b | 0 | 0 |
| c | 10 | 15 |
| d | 0 | 589 |
| e | 55 | 10 |
| f | 0 | 14 |
| g | 2 | 10 |
| h | 1 | 10 |
| i | 0 | 3 |
I have tried multiple options from conditional columns, to DAX as well as creating a column.
Nothing works for me.
Power BI Forums were of no help to me.
Thanks and BR
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
3 Replies
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 _ EasonCalculated 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
