24 februarie 2012 16:00It is possible to perform set analysis using PowerPivot. What I mean is, In SQL Language, can I do Union, Except, Intersect OR do Inner Join, Left Outer Join between different Pivot Table ? Finally trying to get all the data in a form of Venn Diagram.
27 februarie 2012 04:38
In PowerPivot, you are establishing relationships between tables (from a base table to a lookup table). As such, you are not really performing set operations over the datasets. However, you can do this as part of the data loading process you execute to retrieve data into the Vertipaq engine. Also, you can compare datasets to find out common keys across tables, or keys that are missing from a table, for example. You would do this purely in DAX, and though it allows you to find, for example, the keys that belong to the intersected population or rows among two tables, it won't produce the same behavior as the TSQL intersect (which outputs one resultset)
- Marcat ca răspuns de Challen FuModerator 5 martie 2012 10:08