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

DATESYTD returns no value

I have a "sales" table containing all sales data and created a measure: Total Sales = SUM(std_adi[Nettopreis]) this works fine in power pivot. Now I want a DATESYTD() measure and used: Total Sales YTD = CALCULATE([Total Sales],…
f0rd42
  • 1,429
  • 4
  • 19
  • 30
0
votes
2 answers

Power BI: DAX formula to find number of days between dates gives "an invalid numeric representation of a date value was encounted" error

I've just recently begun using Power BI and DAX for my new job, so if this is a super simple or stupid fix I apologize. I'm trying to create a column (NumDays) that calculates the number of days within a date range, and a column (NumWorkDays) that…
mashedpotatoes
  • 33
  • 2
  • 7
0
votes
1 answer

Powerpivot sum from dimension table

I am a graduate intern at a big company and I'm having some trouble with creating a measure in PowerPivot. I'm quite new with PowerPivot and I need some help. I am the first person to use PowerPivot in this office so I can't ask for help here. I…
japie07
  • 1
0
votes
0 answers

Cumulative sum in PowerPivot

Tried for a while now, but I couldn't solve the following issue: I have a data table in Excel, which looks like the following: Data Source Table What I'd like to have is this: Output from PowerPivot I encountered the following issue: When I…
Maxi Eisen
  • 1
  • 1
0
votes
0 answers

Sharing a power pivot enabled Excel file with power pivot slicers with users who don't have power pivot

I have an Excel file that uses Power Pivot to produce several pivot tables with Power Pivot Slicers. I have shared the file with users who do not have power pivot installed, and they can see the pivot tables with no problem. However when they try to…
Essi Shams
  • 159
  • 1
  • 13
0
votes
1 answer

ADDCOLUMNS alternate in powerpivot 2010

Can anybody please guide me theough. I am new to PowerPivot using 2010 addin. I cant find ADDCOLUMNS dax function which is available in powerpivot 2013. Please advise an alternate to this function for 2010. Thanks
Kaiser
  • 53
  • 2
  • 4
  • 11
0
votes
1 answer

DAX Counting Values in previous period(s)

I have a Month Column with the Month Field populated for each line for the 100K of lines of data I have. I need to count the amount of times the Month Field is populated in the Previous Month (Period). I also need to count the total amount of times…
Dave Conva
  • 1
  • 1
0
votes
0 answers

DAX distinct count using different filters in power pivot

I'm having a list of orders and orderlines and would like to be able to Count the number of orders by different filters, e.g. by item, payer, warehouse. My issue is that i get the number of lines calculated. I've tried two different…
Jan Boldt
  • 135
  • 10
0
votes
1 answer

Linear programming with power pivot

I need to make a best case scenario analysis in a spreadhseet heavily built over Power Pivot. So I was wondering if it would be possible to make a linear optimization within PP. The problem is as follows: I have N carriers, each one with a price per…
Vitu Tomaz
  • 61
  • 1
  • 8
0
votes
2 answers

DAX code to count orders with crossed categories

I've got a list of units which are being sold by a shop. Each line describes date, order number, number of units and category (A and B in this example). How can I, using just DAX measures in a pivot table, know how many orders are both in categories…
jormaga
  • 301
  • 1
  • 2
  • 13
0
votes
2 answers

SQL analytical function to DAX

Although it might sound like I want to add window function to powerpivot table, but I'm not... I want to exclude records based on windowing function. I have such a query similar to this (SQL Server): Select Line_Number, Suite_name, …
sliber
  • 11
  • 1
0
votes
0 answers

Converting nested functions from Excel to PowerPivot

First time posting, but I'm at my wits end. I have a workbook with about 8,000 rows, but it's bogged down by several fields containing nested, conditional statements. (sumifs,averageifs,countifs) So, trying to migrate to PowerPivot, but have no…
Evan
  • 1
  • 1
0
votes
1 answer

Excel Powerpivot Calculated Field

I am having an issue with how to get excel's powerpivot to calculate the most recent score with UPDATING and historical data. Suppliers are audited multiple times over the years the score changes and I need the powerpivot to count only the most…
songgirl101
  • 11
  • 3
0
votes
1 answer

Compare 2 datasets using PowerPivot

I have to compare different datasets to find deviations between them. Datasets are always a multicolumn table (up to 1000 columns). Currently I use plain Excel workbook and compare 2 sheets cell-by-cell with a…
Shurov
  • 400
  • 1
  • 9
  • 20
0
votes
0 answers

How to specify Excel default proxy when streaming Excel via VCS

I would like to using Excel with PowerPivot to read data from an SSRS report. When I try and access the report using atomsvc, the connection works fine, but I get the error: "The remote server returned an error: (407) Proxy Authentication Required."…
majjam
  • 1,286
  • 2
  • 15
  • 32
1 2 3
…
99 100