Forum Discussion
Jacklyn
3 years agoFrequent Visitor
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!
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.