User interface for SSAS Tabular, Excel PivotTable or Powerpivot RRS feed

  • Question

  • So far to drill down the data I have been using the pivot table from excel, using "From Other Sources", then "Analysis Services" , and then I have all the cube information available for queries. This is SSAS Tabular model.

    Should I be using Powerpivot instead of this?

    I need to be able to create DAX measures from within excel (some ad hoc calcs which are not available on the cube yet, the user wants to see, possible show the users how to create DAX measures). I guess DAX measures can only be created from PowerPivot (I could not figure out how to create DAX but not MDX measures from PivotTable).

    Basically I need to add DAX measures to PivotTable and could not figure it out. Thank you

    Gokhan Varol

    • Edited by GV1973 Saturday, July 23, 2016 3:19 PM
    Thursday, August 15, 2013 3:43 PM

All replies