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...
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:
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...
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...
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...
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...
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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.
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...
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
What I want is to keep only...