### Divide amount per date by distinct count of dates in a month

Hello First of all I am using Excel Power Pivot 2016. There are a number of dates and each date has an amount. I used 5 for every row as an example (Screen 1). I want ...
| 3 Replies | 524 Views | Created by NeYk - Monday, April 6, 2020 3:07 PM | Last reply by Herbert Seidenberg - Tuesday, April 7, 2020 2:51 PM

### DAX Question: copy column value but change at certain interval (text)

I would like to copy the rows from the first column to the second.  Whenever the logic comes to a row with "VC" I would like "VC" copied ...
| 0 Replies | 303 Views | Created by NoVA247 - Tuesday, April 7, 2020 12:35 PM

### Power Pivot - Sum records split by percentages in columns - SUMIF?

Hi, I have a table where  records are created by a user but can then be split/allocated (as a percentage) across other users.  Please can you advise on a way I can create ...
| 4 Replies | 522 Views | Created by StuBarby - Wednesday, April 1, 2020 9:25 AM | Last reply by Herbert Seidenberg - Thursday, April 2, 2020 5:56 PM

### Using a measure as a filter

I created a measure to sum the total square footage used by an event.  What I want to do is count only those Events with a SUM Square Feet of 100,000 or ...
| 1 Replies | 476 Views | Created by RB Robert Brooks - Wednesday, April 1, 2020 8:11 PM | Last reply by RB Robert Brooks - Thursday, April 2, 2020 3:31 PM

### Create a measure to calculate existing customers

MIN(V_PBI_FINANCE_PAST10yrs[TRANSDATE])))) But it is not really working :( Any help would be much appreciated!  Also the data ...
| 1 Replies | 407 Views | Created by Helen K W - Monday, March 30, 2020 11:25 AM | Last reply by Herbert Seidenberg - Monday, March 30, 2020 10:24 PM

### DAX - Find first occurence of value in calculated column

Hello! I have a list of ID's that have duplicates.  I want to create a calculated column (Unique ID) that identifies the first occurence of each ID in the first ...
| 4 Replies | 2732 Views | Created by undergrads1 - Tuesday, November 19, 2013 4:47 PM | Last reply by Herbert Seidenberg - Saturday, March 28, 2020 10:32 PM

### option of a free text as a filter

Hi People! Is there a way to filter by a free text in Power BI Desktop? Theres a "List" and "Dropdown", but I couldn't find something ...
| 1 Replies | 461 Views | Created by ThomasYaris30 - Tuesday, March 24, 2020 8:29 AM | Last reply by vipulrajput - Wednesday, March 25, 2020 5:35 AM

### creating percentile bins at weekly level for daily data

atomic level of data i.e unique for every date source (string) lang (string) wt (double) imp ...
| 1 Replies | 524 Views | Created by ds_ramakant - Tuesday, March 10, 2020 5:11 AM | Last reply by Herbert Seidenberg - Thursday, March 19, 2020 1:30 AM

### Average divided by number of months in filter (Excel Power Pivot)

Hello I’m a new user, using Excel Power Pivot 2016, that’s why I can’t upload images. I want a column in my pivot table that allows me to see ...
| 2 Replies | 597 Views | Created by NeYk - Tuesday, March 10, 2020 10:52 AM | Last reply by Herbert Seidenberg - Friday, March 13, 2020 5:21 PM

### DAX Formula to calculate when no event is taking place

I have a table of events with start and end dates.  Event ID Start Date End ...
| 5 Replies | 572 Views | Created by RB Robert Brooks - Tuesday, March 3, 2020 8:09 PM | Last reply by Herbert Seidenberg - Friday, March 13, 2020 4:34 AM

### Creating a GUI Interface

I have an estimation workbook that I created in Power BI. I would like to create a GUI Interface for the end user to complete a form that they can enter information for the new project. It would ...
| 0 Replies | 395 Views | Created by Cicely - Thursday, March 5, 2020 2:37 PM

### Data Model Calendar has Fiscal Month field, but display Month name

I was using a shortcut involving TOTALYTD to sort my pivot table by Fiscal Month, but I noticed this caused some issues when trying to drill down.  I added a column to the Calendar date table in ...
| 2 Replies | 492 Views | Created by RB Robert Brooks - Wednesday, February 26, 2020 3:21 PM | Last reply by RB Robert Brooks - Friday, February 28, 2020 7:43 PM

### A way to let users create report, but don't see or edit other's

Hi People! Is there a way in Power BI in a specific WorkSpace to let users create reports, but not to see or edit other's people reports?
| 1 Replies | 448 Views | Created by ThomasYaris30 - Wednesday, February 26, 2020 12:37 PM | Last reply by Darren Gosbell - Wednesday, February 26, 2020 8:30 PM

### PowerPivot IF Statements

Hi, I'm new to PowerPivot. I understand the syntax is different than a regular excel formula. Was hoping I could get some help with an IF statement. Here is my formula in excel, which works just ...
| 1 Replies | 525 Views | Created by aj0702 - Sunday, February 23, 2020 10:32 PM | Last reply by RB Robert Brooks - Wednesday, February 26, 2020 3:42 PM

### Measures not selecting correct data, then Pivot Table displaying Sub Totals that ignore filter

I'm going to try to be descriptive and describe this issue in order, but I know I'm going to leave something out no matter. This is the input file.  There is an Out Date ...
| 1 Replies | 485 Views | Created by RB Robert Brooks - Wednesday, February 19, 2020 3:35 PM | Last reply by RB Robert Brooks - Wednesday, February 19, 2020 4:24 PM

### related table not working

I have the following relationships: dimdata - factsubset - dimsite and dimdata - allfact - dimsite dim data has key data in a 1-N relationship active with both factsubset and ...
| 0 Replies | 370 Views | Created by berli - Monday, February 17, 2020 9:09 AM

### DAX Formula filter propagation elementary question

This should be a simple question because I am new to DAX and PowerPivot. I was using the AdventureWorks 2017 sample database and wanted to show my current employer some of the analytical ...
| 2 Replies | 669 Views | Created by RB Robert Brooks - Wednesday, February 12, 2020 3:27 PM | Last reply by RB Robert Brooks - Thursday, February 13, 2020 1:22 PM

### DAX Formula filter propagation elementary question

I'm relatively new to this and thought I understood how filter propagation works, but when I tried to do a simple count of number of employees on this sample AdventureWorks2017 HR database after ...
| 2 Replies | 500 Views | Created by RB Robert Brooks - Tuesday, February 11, 2020 1:38 PM | Last reply by RB Robert Brooks - Tuesday, February 11, 2020 6:49 PM