powerpivot

Hi Guys Im looking for some help on a formula in a powerpivot to bring back the latest date for each Customer I am currently using =Maxx(filter(query,query[Customer]),query[Last_sale_date]) but doesn't seem to work Any advice Regards Soph

Afternoon All, Before I begin, I know that you can't implement true RLS in excel - but due to pricing, Power BI is a non-starter. These excel models will also not be shared outside of my organisation. The solution I'm using is obtaining the windows username via VBA, pasting it into a cell/table...

Hi, would appreciate any help on this... I have a PowerPivot which imports 1,988,837 rows from an external connection, it gets to 1,980,000 but doesn't complete. I'm running 64bit Excel with 16GB RAM, Task manager shows RAM and Disk use near 100%. Is there a way to import the Rows before it...

Have a large file (157mb) with 50+ pivot tables and each pivot table is tied to powerpivot models (4 main data loads).... Each time I adjust a filter... I get "reading data..." for 30+ seconds... Having to adjust 50+ pivot tables in this manner is a gigantic waste of time and i'm left wondering...

I am using Power Query and Power Pivot. I have a list of support tickets with dates opened and dates closed. I want a pivot table to count the number of tickets opened for a month and number of tickets closed for the month. When I create a slicer for each, it has to be two separate slicers. An...

Hi I can't seem to find the code that would allow me to control a Power pivot Pivot table with more than 1 filter. I got it to work for 1 filter but not if there are more than one. Recording doesn't help. Normal pivot work as well. issue is only with Power pivots

Hello I am having challenges with sort order within a powerpivot. I am attempting to follow instructions on cascading totals, and in those instructions, is the dialog box shown below. I have researched and looked for this option in both the underlying table and corresponding data model table...

I removed a query from my model (using Powerquery and Powerpivot). I went through and made sure that query is not referenced in any PowerPivot formulas or any Powerquery coding. When I hit refresh it tells me it cannot find this query to refresh. I see when I go into existing connections the...

I have an interesting one here. I'm looking to try and substitute the text from a cell into the measures portion of a CubeValue formula in Excel. The CubeValue references data from a related sheet in PowerPivot and I'm bringing over multiple columns of numbers so it would make life easier if I...

Hi, i have 3 xlsx. files in exactly same format each numbering about 750.000 rows, i can export either as xlsx, csv or txt. I have tried in vain to create a single Excel file by copying data in one file, but Excel crashes every time. So here is my questions: 1. Can i consolidate the files in...

For a couple of years I am a happy PowerPivot user. However, I've got an issue I haven't experienced before: I have a CSV file, delimited by ';', with some decimal numbers in it. In my country, we use ',' as decimal seperator. When I import this CSV file with PowerPivot, I convert some columns...

I have some code that works perfectly with a normal pivot table, but does not work if I apply it to a pivot table in a PowerPivot workbook. After doing some research, it seems that VBA doesn't exactly work as usual with PowerPivot. I have a named range of values and I'm trying to filter the...

Hi, i am a very happy user of Powerpivot, but i have one question: I use the Calculated field in Excel to for example calculate the price per unit, by dividing the total costs with the number of units. If calculate this division with a column in the Table, it will not give a correct result, as...

Here is picture of needed data. There is a piece of data (table 1). Primary data starts with March 2010 and I filtered it by Employee 1 and Employee 100. As you can see Employee 1 was not at the Project in May and December, so in May Total Expenses change was -$700. One part of my task is to...

Hi everyone, I am starting to use the relational and Power Pivot databases, so I do not have much knowledge. I have to make a comparative report between two different annual periods. The purpose of the report is to compare the [Gross Margin] of 2017 with the Accumulated [Gross Margin] of 2018...

Hello, I am trying to create a formulae in powerpivot that calculates time between two date/times, ignoring hours which are down hours i.e. If Start Time was 04/01/2018 05:53:00 and End Time was 05/01/2018 07:33:00 the answer should be 1060 minutes. Attached is the table. Ideally i would...

Is it possible?

Hello Everyone, I am looking for a dax function measure for powerpivot report which would return the value based on a lookup value from different table. For Example,I have 2 tables as follows <tbody> City Name State_Code Mumbai MH Pune MH Chennai TM Noida UP </tbody> <tbody>...

Hi MrExcel Members, I have the following issue: I have made a code, which filters a pivottable - it looks like this: Worksheets("Top Suppliers by EUR").Activate ActiveSheet.PivotTables("CreditsbyStyleTable").PivotFields( _ "[Dim_Purchase...

Hello, I’ve been searching for an answer for this for 2 days and cannot find a solution or I am not able to understand one if I see it. I’m new to DAX. I’m trying to create an end product of a Powerpivot report showing sales by: Product Category, Product Number, Product Sales Price, Sales...