powerpivot

Hi, I'm new to DAX, but I'm sure the solution here should be relatively easy? Any elegant solution gratefully received. I need to be able to report where, between 2 Forecast versions, the Closure date for a Project has slipped (or accelerated). I've used 'Calculated Items' within an ordinary...

Dear All, I regularly use Power Pivot and Pivot tables for various analysis and drill through the figures to see what combination of transactions makes those figures. In my raw data there are 44 columns. Every time I drill through, I get an exploded view of that table showing raw data - all 44...

Hi I need help trying to understand an error when using below cube value formula, I have a column of "system" which when using in the formula will make everything error however if I was to use another column to slice by everything works fine, in order to solve this could you give me some reasons...

Hi all, I'm trying to write a DAX for an IF function where there are multiple criteria and true answers but it keeps getting stuck and generating on 1 answer for all outcomes any help correcting it would be appreciated. NB all my tables are linked in data relationships. Below is what I have so...

Hello, I've been struggling quiet a lot with this issue and been looking high and low but I'm not able to find any answer. Hopefully some master can help me solve this issue! I have two table, lets call them Table1 and Table 2 in Power Pivot. They have relation to each other through Column...

Hi all, I've been trying to calculate the rolling average of 'employee count' to use in within another calculation but the formula I have doesn't appear to take the last 12 months but the entire column average, any help appreciated. Formula: =CALCULATE((sum('Accident Log'[Count...

Anybody got any ideas how can I work out how to fix this problem? The error message below is popping up: ============================ Error Message: ============================ Value does not fall within the expected range. ---------------------------- Error occurred while setting the Sandbox...

I have a pivot table created in Power Pivot, it's on a sheet ("Sups") that when using VBA to copy and paste will work sometimes and in other instances, it will not, triggering the "Copy method of worksheet class failed" error. The line that triggers the error is below. Any thoughts? Sub...

I'm looking for a better way to calculate control limits for an SPC chart in PowerPivot. I can do it with a small amount of data (~100 rows), however it is very inefficient and slow when doing it on a larger data set =(1000s of rows). The formula to calculate the control limits is: Mean ± Mean...

I am running Excel 365. I have two named tables, one is called "Inquiry" and the second is called "JO." This is a customer service type database, where first we get an Inquiry, which we log in the Inquiry table in the column named "Inquiry Number." At some point, a decision is made on what to...

Hi Guys, I have an issue which seems to be easy but it's DAX so it isn't :-) I have similar Table (called "Data") as source: Added Table to data model then inserted a Power Pivot: count values in column "C" per Date and per Country: I started to get proper values for previous date but...

I am trying to build a pivot table using the power pivot and the data model built from two different files. With this pivot table, I am trying to compare Quarterly 2022 revenue vs. the same period in the prior year. In the data model, I added columns for Q1'22 $ variance, Q1'22 % variance...

Hi all, I am fairly new to PowerQuery. I have 3 columns, each one with a Table (all tables have the same structure and number of rows): When I expand Column 1, every row of the expanded table gets a table for Column 2 and 3, So I get a big number of duplicates. Is there any way I can...

Guys, here's my issue.... I have this data grid that I need to pivot it. Simple. The problem is that the dates comes across (toward the right) of my main columns. Usually, I'd rearrange my data in a vertical rather horizontal direction BUT It cannot be moved as per client's request. Well...

a task I've been set as part of a PowerPivot creation 1.Enter the last rep to have sold to the customer URN on the query tab of the PowerPivot. Now there's no query tab for me on powerpivot and as far as i'm aware query was part of a ribbon thats now get and transform which has nothing to do...

Hi, In PowerBI I have a measure with DaysPastDueDate = DATEDIFF (AUDIT_HEADER[DUE_DATE], TODAY (),DAY) That doesnt seem to work in Excel PowerPivot and it requires it to be a calculated column. If I make the column witrh that calculation it doesnt seem to like it when the start date is...

I have a data connection that contains 3M rows of data. I want to export a subset of that data (total 1.5M rows) to a text file. Can that be natively exported/written to txt file without loading to tab (which obviously is beyond row limitation for a sheet). If it is possible, I would be...

Hi, I'm struggling to get this to work, any solutions would be much appreciated. - data shows forecasted and actual sales for the year. - data has two date cells, 'projected close date' and 'actual close date'. i.e. when we think it's going to land and when it actually landed. - want to create...

Hi, I have a problem getting two tables to work together despite unique relationship. The table 3 has a column (date) which is unique. The Table 1 and 2 have also dates but not unique. When building the relations between these it works fine, but when i excel trying to use these data in a pivot...

Hi, I would need advice on how to create pivottable, based on inputs from several tables. 1. First I have an account masterdata table Account Sign Level hierarcy 1010 1 Unit Balance sheet 5610 -1 PG P&L This table defines characteristics of each account, and if the account...