Forum Discussion

Sime's avatar
Sime
Icon for Helper I rankHelper I
5 years ago
Solved

Custom Column with DAX IF Statement

Hi All,   I'm attempting to create a custom column using an IF Statement and by Dividing 2 already existing columns.   I have tried the following:   IF([JTD Earned Value] = 0, "1", [JTD Earned ...
  • Angith_Nair's avatar
    Angith_Nair
    5 years ago

    Hi Sime ,

    In Power Query, add a custom column and write this code..

    if [JTD Earned Value] = 0 then "1" else [JTD Earned Value] / [JTD Labour Amount @ Cost]

Angith_Nair's avatar
Angith_Nair
Icon for Continued Contributor rankContinued Contributor
5 years ago

Hi Sime ,

In Power Query, add a custom column and write this code..

if [JTD Earned Value] = 0 then "1" else [JTD Earned Value] / [JTD Labour Amount @ Cost]