Solved: Table from Dax to Power Query (M) code

eduardosilvin3 · ‎12-28-2023

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

Ritaf1983 · ‎12-28-2023

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

Ritaf1983 · ‎12-28-2023

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

Table from Dax to Power Query (M) code

Helpful resources

Join us at the Microsoft Fabric Community Conference

Join our Community Sticker Challenge 2025

Fabric Community Update - February 2025

How to Get Your Question Answered Quickly

Join us at the 2025 Microsoft Fabric Community Conference