Hi,
I am trying to say if a value in a certain column is 0 then make that value 0 else use the value from another column. Not sure on the format of the formula though,
Error message is
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.
Thanks for help
I am trying to say if a value in a certain column is 0 then make that value 0 else use the value from another column. Not sure on the format of the formula though,
Code:
=IF([chargfl] = 0,0,[cpi])
Error message is
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.
Thanks for help
Last edited: