Fill up/ down with conditions in Power Query

Рет қаралды 21,209

Күн бұрын

In today's video I will show you how to fill up or down based on conditions. I am going to show you two ways to do it, you pick the one need :)
Chapters
00:00 Intro
01:00 First solution using M language
02:50 Second solution using the UI
Done!
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

Пікірлер: 39

@KamranMumtazAhmed 2 ай бұрын

The tricks you use are unbelievable, you saved my time. thank you so much for this wonderful video.

@shubhamjain2423 28 күн бұрын

thank you very much, you saved my day. Amazing work!

@kashifhaque2085 Жыл бұрын

So glad I found your channel, used the 2nd method shown in the video to fill responses to questions in a dataset. Keep up the good work!

@RonnySadamHusen Жыл бұрын

Love this. I can't find it anywhere on the Power BI Community page, but here I am. Thank you for sharing this.

@wfbane Жыл бұрын

This is so helpful. Thanks! Just knowing that you can Max a text value in this context is enlightening. I think the first method would be preferable if you expect to have more than one value within a group: each one would fill down until a new one was encountered. In the second method, any previous or subsequent values would be replaced with the single Max value.

@GosCee 2 жыл бұрын

My fill down/fill up works fine when I mimic your example. However, the resulting table has only two columns but I need all 12 columns from the Power Query table to be returned. How do I accomplished that?

@kebincui 7 ай бұрын

Awesome tricks!👍 Thanks for sharing

@confidant58 Жыл бұрын

Exactly what i needed! Thank you so much...

@ajaaskelainen 2 жыл бұрын

Thank you! This is a neat solution and very useful. Love your channel :-)

@ljubicar1987 3 жыл бұрын

Hi Ruth, it would be nice if you make some video about rules about how to use PQ gunctions, where to put them in Advanced Editor, and things like that.

@GosCee 2 жыл бұрын

Great! Exactly what I needed. Thank you very much.

@CurbalEN 2 жыл бұрын

Wonderful:)

@mauriciopriego1700 3 жыл бұрын

Thank you, Ruth.

@melodyvieth9435 Жыл бұрын

Your videos are always so helpful! What if I need to fill up/down on 2 columns after grouping?

@lucascolotta3315 11 ай бұрын

Thanks for all!

@TheFlippedGuy 2 жыл бұрын

This saved me *hours* of work, thank you!

@CurbalEN 2 жыл бұрын

Fab!!

@bitips 2 жыл бұрын

Many Many Many Thanks. Great video. Congratulations !!!!!

@CurbalEN 2 жыл бұрын

🥳

@Sannanification 2 жыл бұрын

Very insightful. Is there a way to achieve this in DAX? I am working with a big fact table and using power query is too slow with it

@riazuddin7493 3 жыл бұрын

I have downloaded and installed a gateway which by default is my gateway cluster and through which I published and refreshed a report. Now I have created another report with a new data source but unable to refresh it as while adding the data source to to the previously downloaded gateway cluster the error message appears "not configured correctly". Do I need to download another gateway and add to existing cluster for the data source to get refreshed? If yes, then will I have to download the gateway again and again for every report that I create and add to the gateway cluster? Also what will happen if other colleagues of my organization start preparing the report on their own computer? Will they have to repeat the same process? Or they can use my gateway cluster and keep adding the new gateways to it?

@flyhigh1491 Жыл бұрын

Hi, I have Excel as a source with grupped rows inside (nombers of levels on the left side) is there a option in powerbi to retrive this information about grupping?

@jpdeion8368 Жыл бұрын

Hello, I always like your videos... Small question, I try to duplicate a table from a connection to a direct query on an online dataset. I think I can do it only with a DAX function "DirectQuery to AS" but I'm struggling to do it. Any suggestion ? Thank you

@aerialsmx 3 жыл бұрын

good morning, how would you do this for more than 1 column (example for 3 columns)?

@ajaaskelainen 2 жыл бұрын

I believe this is what you are looking for: community.powerbi.com/t5/Power-Query/Group-by-Rows-then-FillUp-amp-FillDown-for-multiple-columns/td-p/1475453

@paspuggie48 3 жыл бұрын

How weird, I did a similar nested function earlier Ruth with Table.Sort ascending (characters end at top of column) and then Table.FillDown but that Max option I never knew...how cool 👌

@CurbalEN 3 жыл бұрын

So many options!! :)