Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Sime
Helper I
Helper I

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.

1 ACCEPTED SOLUTION
Angith_Nair
Continued Contributor
Continued Contributor

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]

View solution in original post

3 REPLIES 3
Sime
Helper I
Helper I

Thank you both for your assistance. Problem rectified. 

Angith_Nair
Continued Contributor
Continued Contributor

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
Super User
Super User

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?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.