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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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