CODEWITHSUNDEEP
powerbipowerquery
Robert Sebas
Robert Sebas

Reputation: 83

Fill blank cells based on another column in PowerBI

I'm importing a text file that follows the pattern on the first picture. I want to fill the blank cells according the respective color shown in picture two.

Is this possible using the Power Query editor in PowerBI?

Thank you in advance.

enter image description here

Upvotes: 0

Views: 747

Answers (1)

horseyride
horseyride

Reputation: 21393

Right click the column and fill down. If needed, replace blank with null first

Upvotes: 1

Related Questions