This is so helpful! At 2:30mins you have a window at the bottom of the screen where you preview your table, how to I open that window? I don’t seem to have it
After 1 hour of searching through the internet on how to fill down until value changes in other column, I finally found this video and worked like a charm on a data set with aprox 1 million rows. Thanks :) You got a new subscriber.
Thank You, very good trick, but whenever you use a variable in M, it does affect the processing and speed. IF the dataset is huge, then query might run slow?
There is a easier solution if your data is in the same structure and with more variables. You can simple merge date&product, remove price column and duplicates. From the original dataset, create two tables filtering product A and the other one product B. merge date&product for both. Then go back to the unique data&product dataset and merge the one of the tables expand the Price column and repeat to the second one. Easy peazy. Of course, this is for when you dont have many variables, otherwise new tables will need to be created for each one.
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
thanks for sharing. what if we have multiple columns and have to perform fill down and then fill up .
That's a useful technique, thanks for sharing. I always like a solution which has a bit of M manipulation. :-)
It can definitely be efficient than the UI sometimes 👍
Very useful, thanks for sharing :)
I definitely loved it, impressive and amazing this saved me a lot of time....this is brilliant man, thank you
Exactly what I was looking for with easy to follow explaination and instructions!
This is so helpful! At 2:30mins you have a window at the bottom of the screen where you preview your table, how to I open that window? I don’t seem to have it
Great video. I was just searching for it.
This is awesome. Just what I needed to make sure my fill-down does not jump over categories.
Glad it helped!
Thanks for sharing! Is there a way to scale this to Fill down for multiple columns?
I would like to also know if this is possible...
After 1 hour of searching through the internet on how to fill down until value changes in other column, I finally found this video and worked like a charm on a data set with aprox 1 million rows. Thanks :) You got a new subscriber.
Hi John, very nice and useful tip/technique. Thanks for sharing it. Thumbs up!
Awesome. Exactly what i needed
It's very helpful. Thank you so much 👍👍
Glad it helped!
Thank you so much for this video!!
No problem 👍
Thank You, very good trick, but whenever you use a variable in M, it does affect the processing and speed. IF the dataset is huge, then query might run slow?
Yes, performance could be an issue. I was using this in power bi with a scheduled refresh and small dataset so it didn't matter for me.
Good practice to do a fill up as well.
Awesome ! Thanks a lot.
Fantastic Video!!
After countless searches of how to do this exact thing for Power BI, I decided to watch this even though it was for Excel. This video is brilliant!
👍
Nice tip, thanks
thank you, John!
Nice trick John 😉
Thanks Frédéric 🙂
Cool Tutorial,Thumbs Up..Thank You John :)
Thanks!
There is a easier solution if your data is in the same structure and with more variables. You can simple merge date&product, remove price column and duplicates. From the original dataset, create two tables filtering product A and the other one product B. merge date&product for both.
Then go back to the unique data&product dataset and merge the one of the tables expand the Price column and repeat to the second one. Easy peazy. Of course, this is for when you dont have many variables, otherwise new tables will need to be created for each one.
Awesome trick. But this can also be done using the unpivot and fill down right ?
Simply love it! Thanks for sharing this cool trick:)
No problem, glad you enjoyed it 🙂
After so many searches I found this useful video of you, Thank you for sharing the information.
Awesome
Hi, John. This helped me a lot! Many thanks.
You're welcome!
Helpful technique thanks John
Glad it helped 👍
This worked like magic, thank you
This is SO SIMPLE! what a great trick
Great stuff! Thanks :-)
great!!! thanks!!!
You're welcome 👍