Solved: Re: 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

Fabric Data Days 2026

Power BI Monthly Update - May 2026

Power BI DataViz World Championships - June 2026

How to Get Your Question Answered Quickly

Get Fabric or SQL Certified for Free.