power pivot

I'm looking to optimise the following measures with the aim of creating a pivot table containing 'MyValue' and a grand average 2 point moving range centre line (the AverageMovingRange measure below). Because various other fields can be added as filters, as well as ID being grouped by fields...

I'm using Power Pivot (and starting with Power BI Desktop) to analyse client activity at work. I'm working offline with periodically exported data (no hope of setting things up on our CRM/a SaaS service since it's run by a HQ team that never gets back to me). What I'd like to do is to ask our...

Hi there, I am currently using the following two measures with a power pivot table: Sales Count =DISTINCTCOUNT(SalesHistory[Transaction ID]) Sales Frequency (return a “2” if there are at least 3 sales instances, “1” if instances of sales is between 1-3, “0” if no sale) =if([Sales...

Hi all, Situation: I have a backend excel file and I have a frontend excel file. The frontend files copies needed data from the backend table once a user logins. My frontend file creates various reports in forms of pivots and pivot charts. To create these the frontend model uses a data model...

I have two data sets with a column named identically that has very similar text values. I am having trouble creating a relationship between the two in Power Pivot and I keep getting this error "(String Review)Relationship between '*****' and '*****' is a many-to-many relationship which is not...

Hi Experts, Is there an advantage in using a power query to analyze multi-filter tables where the primary key is not ID but a unique name or code (not numerical) ? For example: Name Department Access to roles Validity Say, I make Name and Department as another query, remove...

I have 2 tables in my data model. One, named 'Data Table', has 4 fields: Date, Index, Category and Value. The other is a calendar. These tables are joined on the Date field. I have a pivot table which uses my data model and has 2 slicers applied to it: 'Data Table'[Category] and Calendar[Date...

Hello, I could really use a little help figuring this out. I have a column with 4 possible values current, current 30 Days, Future 30 Days, and Past Due. I would like to figure out how to calculate what percent of Past Due I have in a column. Than you

Hello, I am trying to build a simple report with data from two different tables in power pivot. Is there a way to get the result as in the attached image since the common column "Product" has duplicates in both columns and i can't create a One to Many relation. I use excel power pivot so Many...

The Data I have - extracted (about 80+ columns for different people and about 150 rows for the codes): Contribution Site Codes Person-A Person-B Person-C Person-D 001-5500-000-55 50% 50% 003-6600-000-56 20% 40% 20% 10% 002-8800-000-57 20% 30% 001-0677-000-58 30% 40% 90%...

Hello everyone, I am new to DAX and Power Pivot, I apologize in advance if there is a similar thread I did not see. I am using Excel 2016, I need to use USERELATIONSHIP in the CALCULATE function to use an inactive relationship in the data model (I need it for a slicer). I am using this formula...

Hello, I have the following tables: table name: Concentrado table name: Empresa table name: Moneda The "Concentrado" table accumulates all the operations, the "Moneda" table indicates all the currencies in which operations can be carried out, the "Compañia" table indicates all the...

Hi Everyone, I have a table with a list of Revenue, I want to count the number of orders, which are more than $100, what is the function I need to use..??? I'm new to power pivot. in excel we use COUNTIF, here I'm not use thanks in advance Cheers MS

Hi I’m trying to figure out the last date an employee was paid I have a payroll power pivot table in excel. I would like to put on the employee table what is the MAX date of when an employee was paid. How can I do this. Thanks for your help.

Hi, all. This question is related to my previous question, but a bit more complex. I am working on data more than 1 million rows, so I need to do this in Power Pivot. The screenshot below is an example on how to do it in normal excel sheet. Let's say I have 3 columns: A, B, C; and there are 3...

Hi all, new here. I am working on a data more than 1 million rows, so I need to work it on Power Pivot. Let's say this data has column A and B. When I make the pivot table of this data, I can get the maximum value of column A. Let's say column A has 4 cells containing this value. I want to get...

Hi all A pivot table using power pivot isn't letting me group by dates properly. (If I create the pivot table from the same data using the ordinary pivot table, everything works properly, but If I create it using power pivot the dates are not handled properly.) Creating the pivot table from...

I have written a measure that calculates the volume of a number of items for an order. I now want to write a measure that would calculate how many cartons would be needed for that order. There are three carton sizes which I have defined in a separate, but unrelated table. In essence the...

I've been using this CUBESET function without issue for a couple of weeks to calculate a sum between two dates, but today it's giving me an #N/A error...

Hi. I have a weird problem. If I add a measure to the values, it prevents me from selecting fields. If I add fields, Excel will not allow me to add the measure to values. And the weirdest thing is that it was working, and then said the original pivot table could not connect and became unusable...