Forum Discussion

Pim123's avatar
Pim123
Regular Visitor
3 years ago
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...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

     

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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.

 

  • Pim123's avatar
    Pim123
    Regular Visitor
    3 years ago

    Hi Jing, 

     

    I finally found a solution for my second solution. Thanks for the reply anyway. 

    I tried your solution as well and it seems to work as well. 

     

    Kind regards,

     

    Pim