Forum Discussion
rosscortb
Post Patron
Post PatronFill 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 gro...
rosscortb , You can have a new column like
Column = COALESCE([Position Group],[Role Level])
amitchandak
Super User
Super Userrosscortb ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
rosscortbThanks 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
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?