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 Value] / [#"JTD Labour Amount @ Cost"])

 

And whilst the syntax appears to be correct, I get this error when I click OK.

 

Expression.Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly.

 

I know i can do this in a measure but I need it as a DAX command to SUM correctly in a Multi-Grid control.

 

Thanks in advance.

  • 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]

3 Replies

  • 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]

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    5 years ago

    This part     -    #"JTD Labour Amount @ Cost"   - leads me to think you're in Power Query.   Fair enough but you can't write DAX in Power Query. You need to write M and there is an 'if then else' in M.

    Does that help?

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

    Thank you both for your assistance. Problem rectified.