Top "Powerpivot" questions

An in-memory OLAP cube that can for instance be installed and used in Excel.

Calculating Percent of Total in Power Pivot Model

I have created a power pivot table as shown in the picture. I want to calculate quarter over quarter sales …

excel excel-formula pivot-table powerpivot dax
Accessing MySQL DB into Excel 2010 powerpivot

I have a MySQL DB on hostmonster.com and I am trying import data in excel powerpivot, but having hard …

excel powerpivot
Refreshing Excel Sheets using powershell

I have 10 excel different excel sheet in one folder named test. I want to refresh the data connection and data …

excel powershell powershell-2.0 powerpivot powershell-4.0
Power pivot many to many relationship between two tables

As you can see from the image i have a one-to-many relation ship between these two tables. BUT i want …

excel relationship powerpivot
Dynamic Parameter in Power Pivot Query

We are using Excel 2013 and Power Pivot to build modules that consist of several Pivot tables that are all pulling …

sql vba excel powerpivot
Microsoft business intelligence platform vs QlikView

I have no experience at all with QlikView, but I have read great reviews about it. According to Gartner Research …

business-intelligence powerpivot qlikview powerbi qliksense
Find rows relative to current row's value in excel (DAX)

Is there a way to filter rows based on your current row's value using DAX (I'm using power pivot) ? In …

excel excel-formula powerpivot
DAX - Last Value

I have this table I would like to create measurement get the last traded value for each day. E.g. …

powerpivot dax
Excel 2013 : multiple pivot tables on one sheet (BELOW) each other

I need to create dashboard with multiple pivot table in the same excel sheet one below the other. The problem …

excel powerpivot
PowerPivot: How to identify Max Value per Group in a Calculated Column

I am building a data model within Power Pivot for Excel 2013 and need to be able to identify the max …

excel powerpivot dax