Forum Discussion
Pragati11
Super User
Super UserGrouping data Performance - Query Editor vs DAX
Hello Power BI Experts, I just wanted to understand the difference in the performance based on column calculations done using DAX versus that done in Query Editor. Let's consider creating a sum...
Pragati11 why calculated columns? I use more than 100 million rows of data and with measures, I was able to achieve anything and these were complex measures. First, why you are adding a column? Also, look at aggregation
I personally feel grouping is not a solution in this case.
camargos88
Community Champion
Community ChampionHi Pragati11 ,
I would handle modeling with Power Query.
If you do it using DAX, you are gonna have your original table on the model, with PQ it will reduce your amount of data.
Also, if you need to use this data for more than 1 report maybe it's better use DataFlow, with that only PQ.
Ricardo