Fill blanks in column with a value based on a condition

[rosscortb]

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

[amitchandak]

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

[rosscortb]

@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.

[amitchandak · Accepted solution]

@rosscortb , You can have a new column like

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

[rosscortb]

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

[rosscortb]

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