Power Query M in Real Life Examples | Malina Cierzniewska-Skweres

We welcome back Malina for this meetup event to talk about the M language in Power Query.
Here is the file that Malina used for her presentation
malinowyexcel....
Event Description
During this meetup, we'll explore the practical applications of Power Query M. You will see how leveraging the power of lists can enhance your ability to manage extensive columnar data-sets. We'll also discuss their role in streamlining time-related operations.
About Malina
"Excel was my passion since my first job. I was, and still am, astonished by what it could do: everything!
As I was working as sales analyst, I discovered, that no matter what complex BI system companies are using - Excel is always the main tool. And it's awesome! Especially with VBA.
I just couldn't keep it to myself so that's why I started to teach Excel (2008) and decided to write a blog about this amazing program (2013). To help Excel users make their jobs easier and faster. And... pleasant.
I share Excel's power with other users on my blog (malinowyexcel.pl) and KZbin channel ( / malinac . I also organize webinars, training and Excel online courses."
This is an online event and starts at 18:00 GMT.
Join London Excel Meetup Events
www.meetup.com...
Learn more Excel and Power BI
computergaga.com
#powerquery #msexcel #londonexcelmeetup

[@Computergaga]

Join London Excel Meetup Events www.meetup.com/london-excel-meetup-group/

[@zhuzhu9599]

Wonderful Class, Thank you CGG!!!

[@Computergaga]

You' re very welcome. Malina is great.

[@shanestocks89]

Really good example. Thank you.

[@Computergaga]

Glad you enjoyed it!

[@xeeshanahmad8757]

Hello super heroes ❤

[@Computergaga]

hello, hello

[@xeeshanahmad8757]

Hello Boss, How Are You. Hopes! Doing Well😁

[@Computergaga]

@@xeeshanahmad8757 absolutely. Very well, thank you.

[@DinoAMAntunes]

Hi Hello the pivot table from the 1 example in not in the order of Months, mine is 1, 10, 11 , 12 , 2....9.

[@Computergaga]

Sounds like the month number is stored as text rather than numeric. I would look at changing the data type in PQ.

[@DinoAMAntunes]

@@Computergaga yes tks a lot

[@mrbartuss1]

Another solution instead of List.Generate that can simply be used as a Custom Column: = Table.AddColumn(#"Replaced Value", "Custom", each List.Distinct(List.Transform({Number.From([Start date])..Number.From([End date])}, each Date.StartOfMonth(Date.From(_)))))

[@dannypuype6104]

Thanks for the insights ... can we also have access to the file with the PowerQuery code as produced during the session? Thx If not I have it available if anyone wants. @Enrico in chat: yes you can create a new column with Date.MonthName() like this: = Table.AddColumn(#"Changed Type1", "Month Name", each Date.MonthName([Month], "en-BE"), type text) To have it properly sorted you have to sort the field in the PivotTable by sorting with 'More option' on the Month name, and selection the appropriate Custom Filter List in the dropdown...

[@Computergaga]

Thank you, Danny. I'll check on the files and get them uploaded if Malina provides.