Forum Discussion

Jacklyn's avatar
Jacklyn
Frequent Visitor
3 years ago
Solved

How to replace values / copy down values in a column when the values are different every few column?

I couldn't use a simple replace value function for above, as the 'value' is different after some number of columns. I could manually use the 'fill' then 'down' function in Excel, just wondering if there is a Power Bi Dax formula or functions available to replace Excel "fill' function? As there are 210,000 rows in the spreadsheet

Thanks!

  • Jacklyn 

    Hi,

    If you want to do it on power query side, you can use fill down option.

     

    If you want to do it in visual side, use Table visual. Do not use Metrix Visual.

     

    Thank you.

2 Replies

  • AUDISU's avatar
    AUDISU
    Resolver III

    Jacklyn 

    Hi,

    If you want to do it on power query side, you can use fill down option.

     

    If you want to do it in visual side, use Table visual. Do not use Metrix Visual.

     

    Thank you.