Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
That doesn't work. When I do that, nothing changes and the additional shop order rows are still blank.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |