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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rosscortb
Post Patron
Post Patron

Fill blanks in column with a value based on a condition

Hello

 

I have a column called position group which contains some values and some blanks

Also have a column called role level with some values and no blanks

 

For only the blanks in position group I want to replace with that employees value in role level.

 

So would be something like, 

IF('Spans & Layers'[Position Group] = "" , replace with values of 
'Spans & Layers'[SP Role Level], matching 
'Spans & Layers'[Employee ID]
 
 
I realise I may need to do this in query editor.
Thanks
Ross
1 ACCEPTED SOLUTION

@rosscortb , You can have a new column like

Column = COALESCE([Position Group],[Role Level])

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@rosscortb ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

@amitchandak 

Thanks Link 

 

So, only the blanks in position group should be replaced with that employees value in role level. If position group already as a value then ignore.

@rosscortb , You can have a new column like

Column = COALESCE([Position Group],[Role Level])

@amitchandak That  seemed to work for my demo i sent but not my live?

role.PNG

got it i need to go into the excel file select the blanks and delete the cell, might have been a space or something hidden in it. thanks

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.