Forum Discussion

rosscortb's avatar
rosscortb
Icon for Post Patron rankPost Patron
5 years ago
Solved

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
Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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

    • rosscortb's avatar
      rosscortb
      Icon for Post Patron rankPost Patron
      5 years ago

      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's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

        rosscortb , You can have a new column like 

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