Forum Discussion
Pull data to line with same starting number
I have a column with multiple shop order numbers and another column with a quote number, but the quote number is currently only associated with one shop order number line. I want to pull the quote number down to all shop order lines when the first 9 digits are the same. So in the screenshot below, I'd like the quote # 82568 to be on every line that starts with 15336-008. How do I do this? I'm new to Power BI.
Forgot to tell you that Fill Down works with null values not with blanks so you should first Replace the blanks in the Quote column with 'null' and then Fill down will work as expected.
3 Replies
In Power Query Editor, you may simply right-click on the Quote column header and choose Fill --> Down. That will get you the desired output.
Forgot to tell you that Fill Down works with null values not with blanks so you should first Replace the blanks in the Quote column with 'null' and then Fill down will work as expected.