**0**

votes

**1**answer

12 views

### why powerpivot completly brokes if there is no values?

Can't understand simple thing about PowerPivot.
Why this works:
When this doesn't:
I have just removed attribute "Earned" from "Values" group and PowerPivot completely brokes (in my opinion): ...

**-1**

votes

**1**answer

26 views

### many to many in excel power pivot

I understand that working with many to many table structures in power pivots could be complex:
...

**1**

vote

**0**answers

15 views

### How to overwrite measures at a line level in PowerPivot

I have two tables, each of the same dimension and same level of granularity;
Date, Site, Campaign, Ad Group, Keyword are the columns, with spend as the single measure.
What I am wanting to do is ...

**0**

votes

**2**answers

24 views

### Powerpivot - Flag whether row value in one column exists in another

All I need to do is create a calculated column that flags whether or not the row value in one column exists anywhere in another column within the same table.
id | Code 1 | Code 2 | ...

**0**

votes

**1**answer

26 views

### Combine data from two seperate tables in Power Pivot without using a join based on concatenated key

I have two separate data sources with effectively the same columns
Date
Vendor
Campaign
Ad group
Keyword
Impressions
Spend
What I am trying to do is stitch the data together in a fact table in ...

**0**

votes

**1**answer

26 views

### Names of the PowerPivot tables do not update in PivotTable

I have imported an Excel table into PowerPivot and renamed the tab in the PowerPivot tab. However, when I create a PivotTable in the Excel sheet, I can only see "Table1", etc. instead of the name I ...

**0**

votes

**2**answers

63 views

### POWER PIVOT formula to show previous day based on weekday

I have two columns called
1ST column Calendar Date:
16/02/2015
2nd Column Previous Day:
Yes
Formula I am currently using:
if([calendar Date])=today-1,"YES","NO").
The 2nd column returns ...

**0**

votes

**0**answers

19 views

### Converting traditional pivot table to data model based

When creating a pivot table, there is an option to add data to the data model. If a pivot table was originally created without this option enabled, is it possible to convert it to a data model backed ...

**0**

votes

**2**answers

31 views

### defining a measure of unique value counts

How do I define a measure in a data model (withing the PowerPivot feature) with a formula that needs to get a unique count of values. For example, something like this:
reset_rate := ...

**0**

votes

**0**answers

31 views

### Excel Conditional Formatting disappears unless smaller dataset in filter

Conditional Formatting on a Power Pivot (Excel 2016 32-bit) using a Color bar is working nicely when results are page filtered to a smaller subset. But when nothing is filtered, the CF disappears, so ...

**0**

votes

**1**answer

52 views

### Excel function/Date Table - Defining week and period

Forgive me if this is a rookie question, however I'm kind of at a loss. I've been evaluating the PowerPivot tool for Excel, and one of the guides I came across with how to most effectively leverage it ...

**1**

vote

**1**answer

70 views

### Changing the Workbook Connection String in PowerPivot

I recently had to move a PowerPivot report from one terminal server to another. I was able to get the PowerPivot Data Connections up and running without much trouble. When I click Test Connection, it ...

**1**

vote

**1**answer

40 views

### 'Count Distinct' and Min(date) in the same pivot table?

Is there a way to have in the same pivot table two value columns, one of which uses Count Distinct and the other uses Min(date)? It seems that to have Count Distinct as an option I need to select ...

**0**

votes

**1**answer

46 views

### Loading data to power pivot via power query vs. directly to power pivot

If I'm fine with doing everything in PowerPivot, aside of future proofing in case I may want to edit queries in the future, are there any reasons to put Power Query buffer in between my data source ...

**1**

vote

**2**answers

206 views

### I do not know how to install Npgsql version 3.0.3

I want to install Power Pivot and Power Qwery in Excel for Postgresql. I installed Visual Studio and I installed Npgsql in Visual Studio PM (Package Manager Console). I can see, in Power Qwery ...

**1**

vote

**1**answer

22 views

### Calculate % of filtered values from all values in Excel Pivot Table

I have this pivot table that currently shows how many students failed in a particular subject in a particular academic year. That is, it is now filtered by Pass_Status Fail(which can be either Pass or ...

**0**

votes

**1**answer

64 views

### Is there a way to hide the Field List in an Excel PowerPivot table so that no users can see it?

I've got a dashboard created via PowerPivot that, when the charts are selected, allows users to open the PowerPivot Field List, so they can see things like, for example, the email address of the ...

**0**

votes

**0**answers

37 views

### How can I turn table column headers which hold dates into pivot table and be able to consolidate by fiscal year or quarter

I have a table that we use to standardize client company financial information.
How can I manipulate this table so that I can easily use pivot tables and group the dates by Year or by Quarter?
...

**0**

votes

**1**answer

52 views

### Variables from Multiple columns lookup to insert new column in Power Query or Power Pivot

Apologies for the layout from below but it is a sample with 4 columns.
I need to insert the target from Table below in a new column, based on the Product (Quite a long list) together with the ...

**0**

votes

**0**answers

27 views

### Excel PowerPivot m2m with time series

I have a dataset which I have simplified a bit for this post. From the image you can see that I have two data tables. They essentially list the estimated output from two 'facilities', and the actual ...

**0**

votes

**0**answers

32 views

### Power Pivot for Excel - version 11 not Installing on Office Professional Plus 2010

I'm trying to upgrade the Power Pivot for Excel add-on from version 10 to version 11, but I keep getting the error that Microsoft Excel 2010 must be installed first.
The laptop is running on Windows ...

**0**

votes

**1**answer

74 views

### How do you group by week in Excel PowerPivot?

Say you have a simple sales table in PowerPivot. What's the easiest way to allow the data to be grouped by week in a PowerPivot pivot table?
I know excel's basic pivot tables have a group feature, ...

**1**

vote

**0**answers

381 views

### How to create a 100% stacked column chart if I have total

I'm trying to create a 100% stacked column chart using Excel 2013 Pivot Table to show what % of Column A is of a Total Column B.
However the 100% stack column chart doesn't seem to work if I have a ...

**0**

votes

**0**answers

34 views

### How to merge Excel PivotTable results with another sheet?

I have an Excel spreadsheet, where I have a PivotTable where the X is Location & Commodity. The Y is Fiscal Year. The cell data is a sum of Commodity cost.
The PivotTable is being generated from ...

**0**

votes

**1**answer

28 views

### Change pivot table layout into “more columns”

When I create a pivot table in excel 2010 my table looks like that:
Any suggestions how to get this extra colume filled up with the names within a pivot table?
Or do I need to use power pivot? How ...

**0**

votes

**1**answer

285 views

### Two-way data update with Excel PowerPivot tables (Office 2013)

Background:
We have two excel workbooks: Data and Visual which we are using to track and visualize activities in our project. The Data file is organized like a database: each sheet is a table (which ...

**0**

votes

**1**answer

1k views

### Create a box and whisker plot in Excel 2016

I asked this question on StackOverflow as well, but I realized that this site may be more likely to produce an answer. My question is: how to create a Box and Whisker plot in Excel 2016?
I know that ...

**1**

vote

**0**answers

238 views

### Excel 2013 Workbook Size Optimizer not working

I have a large PowerPivot/PowerView workbook that needs to be cleaned up. Microsoft offers a free tool called the Workbook Size Optimizer for situations like this, but I have not been successful in ...

**1**

vote

**1**answer

121 views

### Powerpivot install fails

My machine runs windows 7 professional (64bit) and I use MS office 2010 professional 32 bit.
I'm attempting to (re)install the powerpivot plugin but i get an error stating "installation of ...

**0**

votes

**0**answers

79 views

### Powerpivot, Calculate(SUM()) with OR Statement?

I've trying to sum a column with multiple or condition, and I haven't been able to figure out how
I could simply have multiple formulas like
calculate(sum(), filter1)+calculate(sum(), ...

**0**

votes

**1**answer

120 views

### Calculate total number of open item at each month in Powerpivot

I want to find a way to calculate the total amount of open items in each month in powerpivot. My data looks like this...
Id Team CreatedDate ClosedDate
01 AAA 1/30/2014 ...

**0**

votes

**1**answer

66 views

### Setup powerpivot on a server?

I have a client that uses PowerPivot. They save the Power Pivot inside Excel files and have pivottable reports in the same Excel files.
They feel that this puts to much strain on their computers. ...

**0**

votes

**1**answer

105 views

### Microsoft Powerpivot button not working

Hoping someone can assist me with this strange Powerpivot issue; I have a single workbook which is not working with Powerpivot. It has a substantial amount of VBA code (much of which is related to ...

**0**

votes

**1**answer

410 views

### How can I make a time by date chart in powerview

I am trying to produce a report of when an event first occurs every day. I'd like to produce a line chart using PowerPivot and Power View that shows the earliest time the event occurs as a line, with ...

**1**

vote

**1**answer

21 views

### Powerpivot: how do I avoid measures from computing until I'm done entering multiple measures?

With Powerpivot, I have many measures (>25) to enter in a dataset that has millions of entries. When entering the DAX expressions for the measures, each time I enter one, Powerpivot takes a long time ...

**0**

votes

**1**answer

120 views

### Powerpivot; Get a datadump from SQL vs creating a data model in excel

I have a SQL table that includes sales and lead data along with detailed account information, and I have another table that just includes detailed account information.
My question is whether it is ...

**1**

vote

**1**answer

237 views

### Excel 2010 PowerPivot: How do I avoid apostrophes being displayed as ââ‚¬â„¢?

When I import a text file to PowerPivot containing apostrophes, they are automatically converted to Ã¢â‚¬â„¢.
I've been manually correcting the few that I find in the PowerPivot window, however when I do ...

**2**

votes

**1**answer

158 views

### How can I publish excel workbook with data populated using PowerQuery to SharePoint or website and have the data refresh on the site?

I have an Excel Workbook that gets data from an API using PowerQuery, to populate the tables. There are also filters and slicers in the workbook.
Is it possible to publish this workbook to ...

**-1**

votes

**2**answers

595 views

### Power Pivot - Average time per item

I'm trying to calculate on average, how long it takes to make each item.
Here is the data table:
Date Item Quantity Operator
01/01/2014 Item1 3 John
01/01/2014 Item2 5 ...

**2**

votes

**1**answer

46 views

### With PowerPivots, find items that appear *only* in one category

With PowerPivot, how do I find items only in one category? Here's an example:
item category number
obera f6 7
artois f7 2
obera f7 3
ella f6 9
If ...

**0**

votes

**3**answers

91 views

### In Excel PivotTables, how do I show items that occur in one category but not another?

Simplified version of my data:
item category number
apples fruit 7
orange fruit 2
tomato fruit 3
tomato vege 9
zuchini vege 2
tomato vege 17
...

**2**

votes

**1**answer

3k views

### calculated column in pivot table from power pivot

From SQL server I have a query that gives me daily transaction numbers for few companies per day, something like
DATE Company Total Tax year
2013-04-24 ABC 50 2013
...

**3**

votes

**1**answer

614 views

### Auto formatting new pivot rows to data bars

I have a pivot table that takes data from database and displays it as a data bars. Problem is, that the data is updated daily - every day new row is added so the pivot table is growing. Unfortunately ...

**1**

vote

**1**answer

2k views

### Listing/grouping variables in PowerPivot table field list

I have data with 60+ variables and I would like to group the variables into different collapsible fields in a pivot table, similar to having different tables in the pivot field list - ie, instead of ...

**0**

votes

**2**answers

5k views

### Excel 2013 PowerPivot add-in crashes Windows 7

Running into a serious problem with little help on solving the issue. Any time I try doing anything with DAX or sometimes just opening Excel application, Excel crashes and gives me the following ...

**1**

vote

**1**answer

471 views

### Import from Folder data source missing from PowerPivot

If I look around on the Internet, I see people have the ability to import all files from a given folder:
...

**0**

votes

**0**answers

405 views

### Does MSOLAP.5 automatically ship when the Power Pivot addin is installed

We have been getting the following error on some user's PCs when they are trying to connect to Analysis Services OLAP cubes:
XML for Analysis parser: The restriction value provided by the
...

**0**

votes

**1**answer

41 views

### Getting #NUM! for outer nests of IF statement division

I have some sales figures for which I have values in pounds, units, and dollars. From PowerPivot, I'm creating a pivot with Periods columns (Current Week, MTD, QTD, YTD) and sub-columns of "Measure" ...

**1**

vote

**1**answer

962 views

### Data Source Credentials issue with Excel PowerPivot

I am using Excel 2010 with PowerPivot. I am trying to go to the Query Editor. When I click on Table Properties, I get a password prompt:
The problem is that I don't know the password and when I ...

**0**

votes

**2**answers

5k views

### PowerPivot Bar is grayed out

I'm trying to begin learning to use adding measures in PowerPivot but the PowerPivot Ribbon is pretty much all grayed out. Can you tell what I did wrong? How do I get the rest of the selections on the ...