Set Analyser RRS feed

  • Question

  • It 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.
    Friday, February 24, 2012 4:00 PM


  • Hi nadirsql

    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)

    Javier Guillen

    • Marked as answer by Challen Fu Monday, March 5, 2012 10:08 AM
    Monday, February 27, 2012 4:38 AM