We need more answerers in this forum! Let me know if you've been part of this community pretty consistently for at least 6 months, have answered at least 100 questions (with at least 1,000 Recognition ...
| 7 Replies | 567 Views | Created by Ed Price - MSFT - Sunday, October 30, 2016 9:50 AM | Last reply by Guoxiong - Monday, November 07, 2016 2:47 PM

### New - Forum Ninjas Blog!

Forum Ninjas blog was launched! The Forum Ninjas blog is the official blog of the MSDN and TechNet Forum members, which means you, if you read this ...
| 0 Replies | 918 Views | Created by Ed Price - MSFT - Wednesday, August 17, 2016 1:00 AM

### Pivot Table based on Power Pivot data model, memory issue

Hi, I have the following data model in Power Pivot Excel 2016 (64bits) : Something ...
| 5 Replies | 94 Views | Created by Bertrandr - Thursday, December 08, 2016 7:57 PM | Last reply by Imke Feldmann - 7 hours 34 minutes ago

### calculate function with OR

How do you set up a calculate function as an OR?  Would it be like this?  Calculated Field ...
| 1 Replies | 35 Views | Created by AlexMartini - 13 hours 12 minutes ago | Last reply by Matt Allington - 13 hours 1 minutes ago

### Row filter vs. calculate

I wrote this calculate function: Calculated Field 1:=CALCULATE([NumberofContracts],OR(COBI_COContract[RenewalType]="Auto Renewal",COBI_COContract[RenewalType]="Opt-In ...
| 1 Replies | 32 Views | Created by AlexMartini - 13 hours 6 minutes ago | Last reply by Matt Allington - 13 hours 2 minutes ago

### switch formula on two columns

How can I reference two columns with SWITCH?  It relates to subsections.  There are four main types in column A and each of these main types has two sub ...
| 0 Replies | 30 Views | Created by AlexMartini - 13 hours 48 minutes ago

### PowerPivot First/Last Value based on another column (DAX)

setup Date, ID, Gate, First_Gate, Last_Gate 2016-01-02, 42, "G1", "G1", "G7" 2016-01-03, 42, "G2", ...
| 2 Replies | 67 Views | Created by Rogge - Thursday, December 08, 2016 7:04 PM | Last reply by Rogge - 19 hours 15 minutes ago

### BI question:Advice to find relationship conflict?

Looking for advice best practices, any tips and tricks to find relationship conflicts. I am trying to create a relationship between 'item' and 'division,' when I try BI says it ...
| 2 Replies | 73 Views | Created by Phil Smith of NHS - Thursday, December 08, 2016 8:47 PM | Last reply by Phil Smith of NHS - 19 hours 39 minutes ago

### Running Total in DAX Problem

Hello; I have a running total for all Opened Problem Reports that works just fine: Open Cnt:=CALCULATE(COUNTA('Problem Reports'[PR ID]), ...
| 1 Replies | 65 Views | Created by RonInOttawa - Thursday, December 08, 2016 4:33 PM | Last reply by Angelia Zhang - Friday, December 09, 2016 8:21 AM

### New table created on every PowerPivot refresh?

Hi My PowerPivot workbook, is generating new tables on each refresh. When opened up the workbook I find a dozen tables named, ...
| 6 Replies | 1032 Views | Created by Ori Tal - Sunday, December 21, 2014 7:46 AM | Last reply by technetcolmar - Thursday, December 08, 2016 7:05 PM

### Length of service accross multiple service agreements

Hi all, My data is in the form of service agreements, each of which have a start and end date.  End date can be blank for open agreements.  I ...
| 6 Replies | 420 Views | Created by GilesRobinson - Tuesday, June 07, 2016 10:11 AM | Last reply by Michael Amadi - Thursday, December 08, 2016 4:48 PM

### cumulative measure

Hi, My model is in PowerBI desktop. I have a: - registration table with user_id as a PK - an order table (no relation ...
| 7 Replies | 189 Views | Created by yan_elf - Tuesday, December 06, 2016 1:51 AM | Last reply by yan_elf - Thursday, December 08, 2016 4:42 PM

### How to return unique combinations based on order date

Hello. I have four columns (many more but 4 important ones). Sales number, unique sale number, type, and date.  I want to return a pivot table that shows each different ...
| 7 Replies | 221 Views | Created by AlexMartini - Tuesday, November 29, 2016 5:53 PM | Last reply by Michael Amadi - Thursday, December 08, 2016 2:38 PM

### Excel data connection does not update when editing Powerpivot connection

Any advise on how to permanently change the connection info (server name) for power-pivot data? How can I push the new Powerpivot connection info back to Excel or edit the greyed out Excel connection ...
| 6 Replies | 1213 Views | Created by Sven_vD - Thursday, October 16, 2014 3:30 PM | Last reply by Kunal Mahtani - Wednesday, December 07, 2016 9:55 AM

### SUM based on Distinct Values of Another Field

Hi All, I am seeking one help to write a formula to calculate values (below is the ...
| 1 Replies | 95 Views | Created by GURSETHI - Tuesday, December 06, 2016 9:55 PM | Last reply by Angelia Zhang - Wednesday, December 07, 2016 2:05 AM

### Excel PivotTable with boolean filter - Force true AND false to be displayed

Hi experts I have 2 data sources that need to be matched. Each source has several fields that need  equivalent values in the other source. Idea is to display a flattened pivot ...
| 3 Replies | 109 Views | Created by CrazyDoubleJ - Tuesday, December 06, 2016 4:17 PM | Last reply by Darren Gosbell - Tuesday, December 06, 2016 10:25 PM

### "PowerPivot is unable to load the Data Model" in Excel 2016 and Windows 10

0        ...
| 6 Replies | 2869 Views | Created by GerbenvO - Thursday, November 19, 2015 7:02 AM | Last reply by Stewart.Bell - Tuesday, December 06, 2016 8:43 PM

### Unable to refresh data in a PivotTable when connecting to an OLAP cube

I have a PivotTable in excel 2010 and I have changed some of the data. How do I refresh the data, without recreating the PivotTable again, to reflect the data that is at the source in the ...
| 1 Replies | 99 Views | Created by NicoleSS - Tuesday, December 06, 2016 10:29 AM | Last reply by Darren Gosbell - Tuesday, December 06, 2016 7:45 PM

### sumx gets subtotals right

When you use MAXX(Calendar,[Total Sales]) it doesn't get the subtotals right, but when you use sumx(values(Product[ModelName]),[Sales per Day]) it gets the subtotals right. Why is this?
| 2 Replies | 118 Views | Created by AlexMartini - Monday, December 05, 2016 6:58 PM | Last reply by Ashish Mathur - Monday, December 05, 2016 11:21 PM

Once my power pivot was working now it gives me an error message.
| 3 Replies | 110 Views | Created by wilson santiago - Monday, December 05, 2016 2:45 PM | Last reply by Olaf Helper - Monday, December 05, 2016 5:15 PM