Performance in Power BI depends upon many different things at different stages. it can never be summarized that doing this inside Power query is more efficient or same is true for DAX as well. but in general, Power BI works best if there is already well relationship between tables are available, where columns are not calculated columns, so first choice is Power query.
Finally I have found what I was looking for. Thank you for your great video.
Glad it was helpful!
Nice video. Thanks
Glad you liked it!
Please provide dataset for practice.Finished watching
which method is the most performatic?
Performance in Power BI depends upon many different things at different stages. it can never be summarized that doing this inside Power query is more efficient or same is true for DAX as well.
but in general, Power BI works best if there is already well relationship between tables are available, where columns are not calculated columns, so first choice is Power query.