Mastering List.Transform in Power Query: Transform Lists Like a Pro!

In this video, we take a deep dive into the List.Transform function in Power Query, a powerful tool for manipulating and transforming data within lists. Whether you're reshaping your data, applying conditional logic, or creating new values, List.Transform makes it easy. Learn how to apply it step-by-step to solve real-world data problems with practical examples!

#PowerQuery #ListTransform #Excel #DataTransformation #powerbi

00:00 Introduction
02:20 Create Month names
04:00 Create day names
04:40 % of the grand total
05:10 difference from the previous value
07:25 Accumulative sum

[IvanCortinas_ES]

Excellent video, Omid. It's amazing what you can do with Power Query. Thank you.

[boissierepascal]

I didn't know you before... Why ??? You're a pure genius to make me understand the Magic of power query. Lots of thanks

[technicalknowledge]

Dear sir very helpful this video for me

I request to you please make zero to hero play list power query

[IvanCortinas_ES]

= List.Transform({1..5}, each Date.DayOfWeekName(_)) ---> Sunday es the first item of the list.
What about if you want Monday like the first item of the list?
Thank you, Omid.

[technicalknowledge]

Dear sir my question is when list function required and what is benifit list function because u done all thing but my question is when is required and what is benifit and how much different type list function we apply our data

[FsoOmar]

Thanks Omid for this
AMAZING video! Especially the last 2 queries (subtracting a value from the one above it (previous row), and the other brilliant one: running total). Both were amazing 👏, !
I didn't get this one, although I searched :
Date.MonthName(29*_ +1) gives a month name!! How?! 🤔 🙄