Stack Overflow
Stack Overflow

Questions tagged [powerpivot]

An in-memory OLAP cube that can for instance be installed and used in Excel. It allows for fast analysis of huge datasets.

PowerPivot is part of the Microsoft Business Intelligence suite and uses SQL Server in the background, but it is geared towards the data-savvy business oriented person. It allows you to easily load data from different sources, put them in a relational database-like format and create relationships between the tables.

When all data is loaded, an OLAP store is created in the background and you can do real time analysis by selecting and filtering to your heart's content.

Also included is a powerful query language called DAX (Data Analysis eXpressions) which use an Excel style syntax to allow the user to perform complex calculations.

Power-Pivot datasets can also be served as part of SharePoint and Microsoft has even put at least one all-in hardware appliance on the market in collaboration with hardware vendors.

The following links provide useful reference information:

Further interesting PowerPivot articles can be found here:

1828 questions
0
votes
1 answer

PowerPivot - Cannot create one to many relationship - Error: Type mismatch

I have created a data model in Excel 2013 which consists of two queries: Table with 1 million rows of data. One of columns stores information on CUSTOMER_ID. Table with 600 rows of data. This is a list of distinct CUSTOMER_IDs, but only VIP…
Blase
  • 23
  • 1
  • 8
0
votes
0 answers

How to get Total and Percentage in MDX - Power Pivot

I want to get the total per year and the percentage in MDX from this dataset... any ideas, thanks. Example
EGSL
  • 141
  • 8
0
votes
2 answers

Sorting portfolios based on criteria (top30%,Middle 40%. and Bottom 30%)

Currently, I have the following table Company---------Date--------Exchange-------Size A---------------2000---------A-------------50 A---------------2001---------A------------…
Myurathan Kajendran
  • 647
  • 3
  • 8
  • 15
0
votes
2 answers

create relationship based on two columns

I have two tables like below Table 01 Company Date Size A 01/05/2000 30 A 01/06/2000 40 B 01/05/2000 80 B 01/06/2000 …
Myurathan Kajendran
  • 647
  • 3
  • 8
  • 15
0
votes
2 answers

Sorting portfolios based on criterias

My current table looks like this Company-----year----size-----Exchange A-----------2000-----80-------A A-----------2001-----85-------A B-----------2002------90------C I want to allocate the companies into two categories "Big" and "Small". For a…
Myurathan Kajendran
  • 647
  • 3
  • 8
  • 15
0
votes
1 answer

How to use calculate and distinct count together in powerpivot

I want to count the following in powerpivot. I have a column with customer numbers and then I have another column with status ("paid", "no") If any of the customer entries are "paid" I want that to count as 1 unique customer. If not, then there is…
amartino
  • 39
  • 1
  • 1
  • 4
0
votes
1 answer

calculate percentage increase in powerpivot

This is my table Company----Year----price A----------2001----50 A----------2002----75 B----------2001----15 I want to calculate % price increase in additional column using following formula %chg for A in 2002=(75-50)/50 So my new table will look…
Myurathan Kajendran
  • 647
  • 3
  • 8
  • 15
0
votes
1 answer

Excel Pivot Table: Hide rows where all measures are blank or zero

I'm using powerpivot as datasource for my pivot table. Using Excel 2013. Just want to hide rows where all measures are blank or zero, like the one selected in the following image:
Jack Casas
  • 914
  • 18
  • 37
0
votes
2 answers

Combining tables with different number of columns, some in common with same header names

Hello. So I am working out of the query editor of a PowerPivot. I have two tables in the PowerPivot window, which I am editing with the query editor in the table properties tab. The tables have a different number of columns, some columns they have…
Brendan
  • 3
  • 1
0
votes
0 answers

Return value from a column based on the value of a second column for a certain range on a third column in Excel 2016 - Power Pivots

Attached in the following image Example of 2 Bus Services I have an Excel table showing 2 bus services (B1 and B2), covering 6 and 13 stops respectively and the times a bus will pass by each one of them (column C). What I need to get on column D is…
Y.Lebec
  • 1
0
votes
1 answer

TOTALYTD returning values equal to sliced values even when filtered by all dates

I have the following columns in my data table: [Date],[Week_Num],[Month_Num],[Month_Word],[Year],[Username],[Transactions],[Gross],[Turnover] I have my pivot set up like this: report filer: [Year]=2016 vertical slicer:…
Jeho
  • 15
  • 5
0
votes
1 answer

How to retrieve the sheet of power pivot window /model back?

Data has been imported into power pivot for excel as tables.These tables are shown in separate sheet in power pivot window. Created charts and pivot tables from these imported tables.Saved and closed. Can I retrieve this separate sheet of power…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

Powerpivot dax filtering rows based on row context date comparison

I'm trying to determine how many return appointments each customer had within a set timeframe from their last appointment. I need to identify per row whether that particular appointment is a 'return' appointment within 48hrs of them leaving their…
Chris Brown
  • 1
  • 2
0
votes
0 answers

Using SQL code with excel power pivot

I'm using SQL code (which I do not know, I just tried to copy from a sample tutorial) to merge documents to use in Excel PowerPivot. I have an excel file called 2014, and another file called 2015. This was the syntax shown in the example to merge…
amartino
  • 39
  • 1
  • 1
  • 4
0
votes
1 answer

Dax sum all fields with same value

I am using Power BI and i would like to know how to sum all the fields of the same value, and then take the percentage out of the total. For example: I have the following table: Computer Name | Manufacturer | Errors …
user3050392
1 2 3
…
99 100