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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Getting error trying to create a custom column in the transformation

I have a report the data is structured (in Excel) as per example:

BuildingSiteEstimatedRepairDateActualRepairDateEstimatedNumberofOffices
Northeast8/1/20228/12/20225
Southeast9/10/20229/2/22210
Central/midwest9/1/2023 50
Southeast7/1/2021 9
Southwest9/5/20229/5/20222
West8/1/2022 3

 

I tried creating a custom column that will calculate the completed number of offices based on ActualRepairDate is null

 

= Table.AddColumn("Completed Business Sites", each if [#"ActualRepairDate"] <> null then [#"EstimatedNumberofOffices"] else 0)

I'm getting error which is "Token Comma expected". When I click on show error, it really does not show anything. However the red line is right on [#"EstimatedNumberofOffices"] line.

 

I'm stumped and struggling with this.. Appreciate your help.

1 ACCEPTED SOLUTION
davehus
Memorable Member
Memorable Member

Hi @Anonymous ,

 

Try using the conditional column as below.

davehus_0-1662673813016.png

 

 

Hope this helps.

Did I help you today? Please accept my solution and hit the Kudos button.

View solution in original post

5 REPLIES 5
davehus
Memorable Member
Memorable Member

You're most welcome. 😊

davehus
Memorable Member
Memorable Member

Hi @Anonymous ,

 

Try using the conditional column as below.

davehus_0-1662673813016.png

 

 

Hope this helps.

Did I help you today? Please accept my solution and hit the Kudos button.

Anonymous
Not applicable

Hi davehus,

I wrote it into the custom column.

davehus
Memorable Member
Memorable Member

Hi @Anonymous , is the measure above what you've actually written into the custom column or is it a copy from advanced editor?

 

Did I help you today? Please accept my solution and hit the Kudos button.

Anonymous
Not applicable

You have helped! Thank you so much. I have accepted your solution. It worked. Now I know how to do this going forward. Thank you again!!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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