Forum Discussion

MikeUS's avatar
MikeUS
Helper I
3 years ago

Fill Empty table cells with previous values

Dear community, have the following table. Sales Price date only occur when sales were made in the months. no sales no sales price. 

 

 

thats the table i'm looking for.

 

in all months without sales (marked in yellow) i need to show the sales price of the last months i sold something. 

 

 

thanks

Mike

 

Need Help

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    3 years ago

    In PowerQuery, select your Sales Price columns and go to Transform > Fill > Down.

     

    After the fill:

     

     

  • MikeUS's avatar
    MikeUS
    Helper I
    3 years ago

    Hi jdbuchanan71, thanks for your fast reply. 

     

    my original sales data table looks like this

     

    in my sales data table i dont have empty rows to fill those with the transform function. 

     

    the first column (Date) is from my Calendar Table = Calendar [Date]

    Sales Price is from Sales Data Table - Column Sales Price

    (i have filtered one Item #Item 1, otherwise the table would contain mupltiple items and prices for each month)

     

     

    My ultimate goal is to compare YTD vs. previous year sales price