Forum Discussion

MikeUS's avatar
MikeUS
Icon for Helper I rankHelper I
3 years ago

Fill Empty table cells with previous values

Dear community, have the following tables.   Table 1 - Calendar Table (Jan 2020 --> Aug 2023)   Table 2 - Sales Data (Sales Date contains multiple items). for the screenshot below, i have fil...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

MikeUS Can you use the Fill Down feature in Power Query Editor?

  • MikeUS's avatar
    MikeUS
    Icon for Helper I rankHelper I
    3 years ago

    unfort. not. 

     

    my (sales) data table look like: 

     

     

    i can eliminate all 0 from the data set

     

     

    but afterwards i see only the months with sales and the transform fill down function will not work...