power pivot

  1. M

    Power Pivot Measure If Statement giving incorrect value

    Hi all, I have a measure if statement to calculate the AAFR based on the different companies for YTD. When I set the filter to 'Maine Group' it calculates the correct value, when I select 'Smyth Steel' it calculates the correct value however if I don't filter the data I get a value approx. 10x...
  2. M

    find the sum total of measure values

    Hi all, I have 5 KPIs created in measures that I want to get a total value for, I've google it all and the best option i can find is : =[Accident KPI Score] + [Site Inspection KPI Score] + [Site Returns KPI Score] + [Operational RA KPI Score] + [NC Target Date Met KPI Score] however this...
  3. D

    Creating relationships in Power Pivot

    HI, recently could not get the relationship form date to fact table in the right direction , i had several tables with date columns and had created a calendar, but the direction was always wrong, so I then tried joining to one of the other tables this worked fine, so I deleted from data...
  4. B

    Filter Power Pivot by the result of a measure

    Hello, I have a Power Pivot table (see below) that shows the emails reply rate (number treated/number received) for the employees of a company, If they replied to at least 80 % of the emails. the target is reached (YES). I have created a calculated column that show for each person, service and...
  5. A

    Creating multilevel level Bill of Materials (BOM) from table with only parent and child data

    Hi, I am trying to convert a report with BOM line data that shows the parent assembly in column A and the child component in column F (see below screenshot). All the data for the child component is contained in each row, with the parent assembly listed for each BOM line. However, the child...
  6. F

    how to install power pivot in office 2013

    i am using Microsoft office 2013. and unable to find power pivot tab in excel. this tab is also not available in COM add-ins. then what can i do? from where can I do the same.
  7. J

    SPC In PowerPivot

    I'm looking for a better way to calculate control limits for an SPC chart in PowerPivot. I can do it with a small amount of data (~100 rows), however it is very inefficient and slow when doing it on a larger data set =(1000s of rows). The formula to calculate the control limits is: Mean ± Mean...
  8. M

    Power Pivot Grand Average issue

    I have a Power Pivot table. In the Values, I have a measure that calculates a percentage. In the Rows, I have two fields and in the Columns, I have one fields. This all produces the values wanted. Next, I need one more column that shows the average of those values in each row. The problem: I...
  9. A

    Is there a way in Power Query to denormalize a table?

    I have worked with Power Query before and thought there was a way to denormalize a table. The original data is State and different ethnic groups as different columns with the rows with population for each ethnic group. I would like the output to be three columns State Ethnic group...
  10. H

    How do I create a table that then considers whether or not clients appear in other tables?

    Hi Guys, Pretty new to excel so hoping there's a simple answer to this that I'm not aware of. I work in marketing insight and part of my role is selecting the best customers to send each of our direct mail campaigns to, and I want to create a workbook in where I can walk through our monthly...
  11. S

    Need help finding current quarter in a non January start.

    Hi, I'm trying to create a DAX formula to figure out the current QUARTER. Below are a few of my attempts. Our year starts Feb 1 to Jan 31. =if(dCalendar[DATES]<today(),if(ROUNDUP(MONTH(TODAY())/3, 0)=dCalendar[QTR],"CURRENT QTD",""),"") QTR =if(ROUNDUP((MONTH(TODAY())-1)/3, 0)=0,4) So...
  12. S

    Slicer update after all slicers selected

    Hi, I have an issue that when I'm working with many slicers I have to wait each time I make changes to my slicers before I can go to the next slicer to make my selections. I wonder if there is a way to work with all slicers before the pivot table refreshes. Thanks
  13. O

    Simple sum measure with multiple filters

    Hi, I am trying to create a power pivot measure that sums with two filters and have tried a variety of ways and it will not work for some reason. There is something simple or obvious that I am missing and guidance would be appreciated. Example attempts below This code works CALCULATE(SUM('09...
  14. R

    Data Model Pivot Table Average Subtotals

    Hello Everyone, I´m having an issue with a pivot table from the data model. I want the quarterly subtotals to show monthly average rather than sum, but the option is grayed out: Is there a way I can work around this? Thank you!
  15. G

    Summarize SUMX grand total as a grand average

    Hi, I have the following workbook to get weighted student grade averages, which I am doing with `SUMX()` in DAX (From what I understand, this is akin to `SUMPRODUCT()` in Power Pivot): =SUMX(grades, [grade] * RELATED(weights[weight])) It's working pretty much as I want, except for the Grand...
  16. X

    Cumulative Monthly Report

    Hi I have a range of data that looks something like the attached image. The data is from an external database that I have cleaned up in Power Query (it wouldn't clean up in Power Pivot) and brought into Excel. I would like to produce a cumulative monthly report that total of requests that...
  17. M

    How to add calculated rows and calculated columns in power pivot table?

    Context: Preparation of income statement through power pivot. Data Source: period wise details of income and expense loaded through external excel file to power query and power pivot model. Left side table: 1. This left side table is loaded to power query and power pivot data model through...
  18. M

    Sort based on unused field in power pivot not working

    I am trying to sort pivot table fields based on sort order given in the table, however system seems to be ignoring sort order. Requesting community members to guide how to achieve required sort order in the pivot table. Sheets in the file: 1. TB- Trial Balance having GL code and values 2...
  19. A

    Filters from many-to-many to one-to-many Power Pivot

    Hi all, I am fairly new to Power Pivot. I am having some trouble understanding filtering between related tables. I have my main table "Demographics", in which "Index" is Unique so: Index Role 1 Engineer 2 Engineer 3 Manager...
  20. A

    Power Pivot Table Does not count rows with blank adjacent columns

    Hi all, I have this data, where all the rows with "Response" as "Distributed" have only blank cells next to it: RoleExperienceResponseIndexDistributed1Engineer≤ 10 YearsComplete2Engineer≤ 10 YearsComplete3Technician> 10 YearsComplete4Technician≤ 10 YearsComplete5Engineer≤ 10...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top