power pivot

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

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

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

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

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

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

Hi All, I am trying to do the following, please let me know if this is possible: I have a "Value Field" called Count of Value_Proficiency which simply counts the occurrence of each Row Label I would like to create a new "Measure" having Max of Count of Value_Proficiency repeated for all Row...

This is cross posted with Excel Forum; DAX Using a Measure in formula produces a blank and can't see why My question relates to the following formula to get the previous value from non consec dates; first I have a filtered down table. Filtered Dates := MAXX ( FILTER ( ALL (...

Hi, I've had a problem where I'd loaded a table into power query, added to the data model and opened in power pivot but when I tried for example to calculate a total so SUMX(Table1, Table[Units] ) , I got an error, If I loaded the same Source excel table into power pivot directly, I could do...

I am not sure if I am asking the right question, but I will try. I am creating a pivot table with data similar to what is shown below: ABCD1SystemIDNameAmount2Payroll5067John Smith III253Vendor5067Smith John254Payroll8855Debbie Brown305Vendor8855Brown R Debbie306Payroll3465Ned...

Hi, Can someone tell me if Powe pivot and Power Bi work differently in relation to date / Calendar Tables, So if I have a meaure ; SUM(TslaesTable[Sales} ) and I use this in a pivot table which is just has Dates in the Rows, if i use the dates from the sales table I get what I would...

Hi Folks. I am newbie to Power Pivot and Power Query. I moved to the Power side since I need to pull form two data sets. My issue is I have created a new Power Pivot and I am using the Top 10 Value Filter for scores, but my data has many recurring values so my top 10 may be 20 or so returned...

hello, I want to create a new calenderer table but the option is greyed out? how do I fix this? Richard.

Hi Everyone, I am seriously considering spending a lot of time building a data model in order to benefit from Power Pivot and DAX. I work as a finance business partner and my role is to analyse data (monthly most of the time) through multiple scenarios (P&L by country, by account, by project...

Hi, Is it possible to have a slicer from one table controlling another, I've essentially set up 3 small tables a date table (marked as such in pq) a product table and a sales table, all are linked. and I like a slicers from the date and product tables to control the pivot table showing...

Hi, can some one tell me the meaning of the orange on 3 of the tables? Richard.

Hello all, I want to create a running total by product category in power query; so far I've come up with the following; <VAR prod = TESTA[Product] RETURN CALCULATE(SUM(TESTA[Qty]),FILTER(TESTA,TESTA[Index]<= EARLIER(TESTA[Index]) && TESTA[Product] = prod))> variable name pod ...

I am trying to use relationships or data models instead of using Vlookups, as Vlookups are slowing down the spreadsheet. 60,000 formulas for a 15,000 row spreadsheet. I am having difficulty getting the information I want. Table 1 is named GL. Table 2 is named CreditCard. The ID is the foreign...

Hi All! I'm a bit new to this, so any help would be highly appreciated! I have a Few Tables, Mainly the "Highlighted below" are my 2 (soon to be 3) primary data tables, Harvest TIME has "time" expenses, Harvest Expense the "Software" Expenses (and dates of the expenses), and later i will be...

Airport Delays and Covid Cases Pivot Table I have two tables joined to a Date lookup table. My flight data doesn't have data for October 2021 to December 2021 but my cases data does. How do I exclude the blank rows automatically without have to click filter blank rows manually. Is this...