Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
3 months ago
Solved

If Condiotion with blank

Hi and good day, can any one help me on my if condition 

if the column 2 is equal to 0 then 0 else column 1

RESULT

Thank you

  • AllanBerces 

     

    Final Column = IF('Table'[Column 2] = 0, 0, 'Table'[Column 1])

    Blank values in Column 2 are treated as 1 since they are not equal to 0.

2 Replies