Hello,
I have some question about the scenarios on when and how to use the EVALUATE/SUMMARIZE function of power pivot.
Let me explain:
- I use a lot power query to crunch data in order to add a the wanted data/tables in the data model
- Then I use power pivot to manage the data model, and create basic measures
- Then i use Excel pivot tables or power view to display data
Very basic I would say.
But I can see now that there is another possibility by using EVALUATE or SUMMARIZE functions, like in these examples :
https://www.powerpivotblog.nl/imple...l-2013-using-dax-query-tables-and-powerpivot/
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
These function enable to create like view (they are equivalent of some SQL instrcutions), make some join from the data model and send the result as an excel table. It seems really interesting.
But actually, I don't figure out how to use these functions and concepts, on which scenario these concpets could be useful ?
* Why would I need to join tables, after having modeled my data into power query and added to the datamodel ? What is the interest ?
* Why would I use them and not for example doing the same job in a combination of power query and basic powerpivot ?
* When it is a good ide to use them ? Why ?
I really appreciate if someone has some experience on them and can report some feedbacks, because for now, for me, it is confusing
Hope I'm clear.
I have some question about the scenarios on when and how to use the EVALUATE/SUMMARIZE function of power pivot.
Let me explain:
- I use a lot power query to crunch data in order to add a the wanted data/tables in the data model
- Then I use power pivot to manage the data model, and create basic measures
- Then i use Excel pivot tables or power view to display data
Very basic I would say.
But I can see now that there is another possibility by using EVALUATE or SUMMARIZE functions, like in these examples :
https://www.powerpivotblog.nl/imple...l-2013-using-dax-query-tables-and-powerpivot/
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
These function enable to create like view (they are equivalent of some SQL instrcutions), make some join from the data model and send the result as an excel table. It seems really interesting.
But actually, I don't figure out how to use these functions and concepts, on which scenario these concpets could be useful ?
* Why would I need to join tables, after having modeled my data into power query and added to the datamodel ? What is the interest ?
* Why would I use them and not for example doing the same job in a combination of power query and basic powerpivot ?
* When it is a good ide to use them ? Why ?
I really appreciate if someone has some experience on them and can report some feedbacks, because for now, for me, it is confusing
Hope I'm clear.