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.
Greg_Deckler
Community Champion
Community ChampionI wouldn't necessarily classify 12 GB of data as huge. But regardless, you generally want to push transformations up the chain as far as possible. So if you can do it in the data source = best then Power Query and then DAX. There are always exceptions but that's generally the case.