1. B

    Relationship won't work on Power Pivot

    I've attached an image with my problem, of course I did this in separate sheets and only copied it into one so it's easy to visualize. I have in the first table my sales and in the second one every article with its brand. I want to know, in each month, how many different brands were sold, but it...
  2. W

    Power Pivot - aggregate within groups to determine max value

    I'm looking for a formula (for Power Pivot) that aggregates within certain groups and across other groups to determine the maximum. Here's my data table: State Customer Fruit Qty NY A Apple 5 NY A Orange 1 NY A Pear 5 NY B Apple 1 NY B Orange 6 NY C Apple 2 NY C Orange 2 NY C...
  3. P

    Power Pivot - calculated column in Pivot Table

    I tried to have calculations of difference between two months in two years in the pivot table from power pivot. I've done some research but couldn't find a way to solve my purpose. Unfortunately, the Power BI is not available only Power Pivot and Power Query. I remember previously in Pivot...
  4. B

    Stuck on analysing support cases (average/high/Low) pivot chart

    So i'm stuck on grating a pivot chart / chart for showing average / high / low trends on time from creation of a supportcase until it is closes. What i would like to have in a chart is how average hours from creation to resolved changes over time. I'm totally stuck on this, so any input is...
  5. C

    Row Header Format is Bold when no children exist

    I am using a calculated column showing the level of an account and several measures to allow children to show only when necessary. However I noticed one thing - Excel Power Pivot treats all row labels within a group as row headers (bold) even though not all have children. In my mind this would...
  6. M

    PowerPivot report - getting multiple filter values and calculating prior year data

    Thanks in advance! I'm creating a PowerPivot based report in Excel 365. I'm reporting actual quarterly sales data, performance against plan, and performance against prior year. There is a calendar table that links to the data table. I'm deriving prior year quarter by taking the value of the...
  7. G

    PowerPivot - Granularity issues with a many-to-many relationship

    I have two fact tables, one that is a list of stays at multiple hotels with 4 columns (Location, arrival date, departure date, member ID), another that's a series of transactions with a bunch of details (location, transaction date, member id, item sold, item category, etc). Both tables have the...
  8. R

    Excel Power Pivot with 2 measures in Value column

    I have an excel Power Pivot, using measures. Here is what the current output looks like. The server column is the result of a measure using a concatenatex function: Note that the Servers exist within a Group, and that each App defined in a Group are all on the same set of Servers. To avoid...
  9. M

    Power Pivot - Change Power Pivot Connection to Power Query Connection

    Hi lovely People! I'm trying to update my power pivot data model to keep a table with my measures but change a Power Pivot Data Connection to a Power Query Data Connection. Using Power Pivot Data Model Connections in my WorkbookDataModel.xlsx This is my table: When trying to edit to get...
  10. G

    PowerPivot CALCULATE SUM

    Hi, would appreciate any help with this, I'm trying to do a calculate sum if in PowerPivot, example of how it workls in Excel below, but am unsure how to replicate in PowerPivot. Thanks in advance for any help. Gav.
  11. G

    PowerPivot Count Duplicates

    Hi, would appreciate any help with this... I have a table of Invoice Data, Including Company Number and Date, I need to count the number of duplicates where a company has more than one invoice for the same day. ( I need to count in PowerPivot itself, as I will be performing more calculations...
  12. G

    PowerPivot Weighted Average

    Hi, would appreciate any help on this, I want to get a weight on groups of rows in my Data using PoverPivot. So for example, the weight by Customer by Product in January. This sort of structure, but obviously a lots more rows ! Is it possible to sum the Amount column by row using variables...
  13. KCRENO7

    Clearing global data source permissions to update Power Pivot, is there another way?

    Hello, I have pulled in data from SharePoint to make my PowerPivot. When I send the reports to others and they go to Data-Refresh, they get the following error message: Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException I found this Work-around : go to Get Data/ Data Source...
  14. L

    Filtering a Calculated Measure From Another Table

    Hi All, My brain is fried again. I have scenario where I have to calculate various stats between two sets of data. The only thing common between the two data sets are the Calendar Weeks and the Supplier Numbers. So I have two tables: Table 1 has all of the supplier claims quantities by...
  15. J

    % calculation with different total for each level of aggregation

    Good morning everyone. In my Excel file I have an "Orders" table which among other things includes the field "Hours needed", which is basically the time in hours required to complete the order and the "Date of order" which is the date when the order was carried out in dd/mm/yyyy format. You can...
  16. L

    Difficulties in creating many-to-many relationships in PowerPivot

    Hey guys, I am currently trying to build a database in Excel that contains all Green Climate Fund (GCF) projects. Recently the GCF published an API that allows internet users to access their project data through the following URL: https://api.gcfund.org/v1/projects. I used the "Get Data from...
  17. D

    Import to Power Pivot..

    Hello, I'm exploring Power Pivot (Power Query, BI) opportunities. I have some 24+ workbooks with IDENTICAL data structure in data sheet and 100K+ rows each. I use a pivot in each workbook. My goal is to have one "power pivot" with all the data (+ additional small reference tables) so I can work...
  18. F

    PowerPivot, Running Totals, and Chart Lines with null data

    Good afternoon all, I'm certain that we've all had this issue at one point or another but I can't seem to find a solution--hoping that someone has something ready to go. Here's the summary: PivotChart with Date values on X AXIS and a Running Value Count 'flattens' when max is reached. The...
  19. W

    Distinct values - Powerpivot

    I've been doing some work to identify some issues with the data in a couple of my database tables. I've got one table [tbl_customer] with a reference number (unique) and details of customers, and another [tbl_sales] with details of the products that they've purchased (many products and many...
  20. J

    Extract unique value from column using DAX

    I've come across what I thought should be a simple problem, but I can't quite figure it out. I have a table that's the result of an expression that could have a column like this in certain instances: Row Key Index <tbody> AH4000 1 AH4000 2 AP9999 3 </tbody> What I want is to keep only...

Watch MrExcel Video

This Week's Hot Topics

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