Forum Discussion

Pragati11's avatar
Pragati11
Super User
6 years ago
Solved

Grouping 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...
Need Help
Show and Tell
Tips and Tricks
  • parry2k's avatar
    parry2k
    6 years ago

    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.

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi parry2k ,

 

May be I am just thinking a lot and started creating columns. Looks like I should start creating measures rather than columns and see how it looks like.

 

Thanks for this suggestion. I will try this.

 

Thanks,

Pragati

parry2k's avatar
parry2k
Super User
6 years ago

Pragati11 sounds great. Good luck. Yeah, always put MEASURES first and every time you think of creating a column, ask yourself, why you need this? Cheers and good luck. Keep posted and let's know how it goes.