Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Custom Column using Power Query or DAX New column

Hi all,   I have a doubt about the next question. Which is better in terms of performance, Custom Column using PQuery or New Column using DAX?   Thanks to all for you answer. 
General Comment
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Yeah, I would say that in your case you should definitely consider moving that to Power Query. General rule is that the further upstream that you can push the calculations, the better the performance downstream.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Ok, thanks so much for your fast answer.

 

I have a model and i need to split some string values from various columns to use later like slicers. The fact table in the model have more than a million of rows and i'm thinking in transform my new DAX columns in Power Query columns to reduce the performance impact when the user use it.

Do you think i should do it?

 

Thanks again.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Yeah, I would say that in your case you should definitely consider moving that to Power Query. General rule is that the further upstream that you can push the calculations, the better the performance downstream.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Yes, I thinked the same.

     

    If somebody need it, here you have a link that explain so well my first question:

     

     

    http://radacad.com/m-or-dax-that-is-the-question

     

    Thanks Greg_Deckler