Forum Discussion
Efficiency question - Power Query vs Desktop
Hi Anonymous
There are different options in different situations. Just like we can't do more transform on the column which was built by Dax in Power Query Editor. As below, it tells you when to choose power query or calculated column.
For more info you may refer to this blog: power query vs calculated column
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak creating a relationship wthin power query to connect data is not efficient as well? For example connecting your date reference table to your main table?
Hi Anonymous
There are different options in different situations. Just like we can't do more transform on the column which was built by Dax in Power Query Editor. As below, it tells you when to choose power query or calculated column.
For more info you may refer to this blog: power query vs calculated column
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.