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

Рет қаралды 1,994

6 ай бұрын

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.pl/wp-content/u...
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 KZfaq 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/london-excel-m...
Learn more Excel and Power BI
computergaga.com
#powerquery #msexcel #londonexcelmeetup

Пікірлер: 15

@Computergaga 6 ай бұрын

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

@zhuzhu9599 6 ай бұрын

Wonderful Class, Thank you CGG!!!

@Computergaga 6 ай бұрын

You' re very welcome. Malina is great.

@Lixhul 6 ай бұрын

Really good example. Thank you.

@Computergaga 6 ай бұрын

Glad you enjoyed it!

@xeeshanahmad8757 6 ай бұрын

Hello super heroes ❤

@Computergaga 6 ай бұрын

hello, hello

@xeeshanahmad8757 6 ай бұрын

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

@Computergaga 6 ай бұрын

@@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

@dannypuype6104 6 ай бұрын

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 6 ай бұрын

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

@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(_)))))