Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
eduardosilvin3
Helper II
Helper II

Table from Dax to Power Query (M) code

Hello all, I need this Dax Table in Power Query (M), any ideas? Table from the extraction to create this is in Power Query (SQL) so I have all the data but I do not have a lot of experience in Power Query.

Thanks

 

eduardosilvin3_0-1703759117385.jpeg

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @eduardosilvin3 
Instead of summarize you can use group by in power query.

https://www.youtube.com/watch?v=aR5sFhMSENg

instead of union append

https://www.youtube.com/watch?v=A-KOWgSPG00

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @eduardosilvin3 
Instead of summarize you can use group by in power query.

https://www.youtube.com/watch?v=aR5sFhMSENg

instead of union append

https://www.youtube.com/watch?v=A-KOWgSPG00

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!