Forum Discussion
Solved
Filling missing prices in dataset
Hi, I'm trying to get the below graph with a total price of a item basket against QTY. The red line shows the price development of the price basket. In my data set not every item has been sold i...
Hi Pim123
Based on the current table structure, the first solution would be easier. After changing column types, you can select all "Product X" columns and use Fill Down to fill the null values. Notice that this is done with Power Query Editor.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Better picture of the table: