Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Bridge Table - Do in PowerQuery or in Dax?

Hi I'm creating a bridge table, but I'm unsure about if this must be done in PowerQuery thought a Reference or thought a DAX expression. If I create it thought a DAX expression, it's very quickl...

v-yuta-msft
6 years ago
Anonymous ,

I've found several third-party blogs which may help you:

https://radacad.com/m-or-dax-that-is-the-question

https://technologyblog.rsmus.com/microsoft-dynamics/dynamics-365-for-finance-and-operations/difference-m-dax-in-power-bi/

https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/

Community Support Team _ Jimmy Tao

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

Icon for Most Valuable Professional rank

Most Valuable Professional

6 years ago

Hi Anonymous ,

check this Blog Post from Chris Webb

Why Does Power BI Query My Data Source More Than Once?

https://blog.crossjoin.co.uk/2019/10/13/why-does-power-bi-query-my-data-source-more-than-once/

Maybe it helps.