powerpivot

Hi all, This forum has already helped me so much in the past months but now I have the first question I couldn't find an answer to anywhere else, really hope someone can point me into the right direction. I have an Excel model where I use a data model and power pivot. Basically user enter the...

Hi, I would like my POWER QUERY to filter only a select date range. Sales from 730 days ago to 830 days ago. Sales from 365 days ago to 465 days ago. Sales from today to 100 days ago. Here is my current code: SELECT tblsale.sale_link, tblsale.loc_code AS [LOC#]...

Beste, Mijn voormalige manager, CEO van Ypto, de IT leverancier van de NMBS, zoekt dringend een excel expert met kennis van PowerPivot en PowerView. Het betreft hier een korte opdracht van ongeveer 1 week. Mogelijks kunnen nieuwe opdrachten volgen. Als je in België woont en interesse zou...

I have three tables. I'd like to work with them using data connections in Powerpivot so I can create simple Pivot tables. The tables are: One is a fact table with the usual customer, product number, sales, gallons, etc. The second is a lookup table which allows me to lookup a "cost center"...

Hi Forum, Quite straightforward I'm sure - but I'm new to measures in PowerPivot. I have three columns; Definitive Name, Yr.Mnth & Employee FTE. The table name is 'Summary Query'. I need a measure that will calculate Employee FTE based on the number of times that 'Definitive Name' appears in...

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: 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...

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...

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...

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...

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...