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 Community Champion rank

Community Champion

6 years ago

In general, the more that you can move data manipulation up the "food chain" towards the source the considered the better way to go. That being said, DAX makes it super convenient to do these kinds of things. Also, to your point about efficiency, both methods would have the same efficiency in terms of data storage in the model. I would expect that after the first time, the Power Query would be faster than the DAX in terms of loading the data into the model but I have not tested that.