Dynamic Coalesce in Power Query ( Record.SelectFields() )

[@datawizibility]

Awesome....great way of teaching... making complex things so easy ...

[@malchicken]

Best power query vids. Unfortunately, I don’t really see your videos shown under related videos when I watch power query videos. To consider, maybe adding hashtags to the description or related channels to your channel page will help the KZbin algorithm show your videos for related videos.

[@rick_.]

I always learn something from your videos. BTW, you could also have used List.Skip(,2) to remove the first two columns, either for filtering the column names or when selecting the record values. = Table.AddColumn(Source, "Coalesce",each List.Last(List.RemoveNulls( List.Skip(Record.ToList(_),2))))

[@ExceedLearning]

Glad you find our videos helpful! :) Yes, for the first part of the video we could have used List.Skip, as it would return the same result. However, using Record.SelectFields is a more robust solution. When we moved the column Type (at around 8:00), the solution with List.Skip would remove the column Jan instead of Type, and it would return the wrong result.

[@norbertschmidt6532]

Dear EL, thanks, great and super.

[@TylehurstXL]

So thats what _ means ! Thank yiu fir explaining. I ve been doing PQ for 1 year didn’t know.

[@smvpegb]

thankyou for this video is very helpful

[@silverfunnel6819]

Very useful. Thank you!

[@engahmedelbendary1566]

thx alot for your Effort and go on

[@silverfunnel6819]

It would be interesting to have the corresponding column name in a new column🙂

[@umangdbz]

Awesome bro !

[@vacilando86]

Awesome

[@SamehRSameh]

We Need more about M language and power query

[@epernayjfl]

Bonjour et merci pour ce partage de connaissances ! Poster votre fichier exemple serait bénéfique pour nous ! 😉

[@ExceedLearning]

¡Hola! Encuentre el vinculo al archivo de Excel a continuación 😄 exceed.hr/wp-content/uploads/Coalesce.xlsx

[@MrWella1234]

Thanks for the tutorial. What about if you use the "Record.RemoveFields" insted of "Record.SelectFields"? then you can remove the name and type column and then it will be dynamic.

[@ExceedLearning]

Hi, It is true that by using Record.RemoveFields you can achieve the same solution (similar to remove columns or remove other columns in the PQ user interface). We used Record.SelectFields because sometimes there are more complex filter conditions to evaluate, and that's where the Record.SelectFields can be a better choice.

[@kartik-wi2jv]

Excellent explanation, can you help me, how we need to refer to the previous row value in power query, for example, calculate date difference of current date and previous row date.

[@kndeepak]

Add and index column and refer to current row index -1

[@marcosflatron]

Volim te 🥰