powerpiviot

Hi, I'm trying to build ad "Intelligent" date frame slicer. (like YTD, MTD etc.) I found this video () showing how to do it in Power BI but this will not fit into PowerPivot. Any ideas how to implement similar in Power Pivot? Best regards, Hakan

Hi All, I need some advise and ideas. I have a huge Excel dashboard containing a data model with +600t records which I update every week. Then I distribute the Excel file to every user that save a copy of the Dashboard.xlsx on their own computer and uses it as such. What I would like to do, is...

Hi, I have a workbook that is connected to my BI database through Power Pivot. I have some VBA which refreshes all the connections & creates the workbook. I would like some VBA that brings up an error message if one of the connections fails to refresh - similar to if I was to refresh through...

Hello - I’m trying to make a P&L statement from a trial balance in PowerPivot vs. the historical lookup method. In a simple example, this was easy to do in PowerPivot, but now that I’m trying to add in a pairing that needs to occur I cannot create the relationships. In my simple example I have...

Hello, I found this thread and it was spot on for what I needed. However, I'm using the script below for adding notes for invoices that are then pulled into a PowerPivot, but it hangs on Pivot refresh if I put more than one note per invoice number (I'm using the invoice number as a relation...

Hey all, I have tried to the following CUBE formulas in order to get a value based on results from two columns within a dataset inside Power Pivot, however they all return blank. =CUBEVALUE("ThisWorkbookDataModel","[Measures].[Path PP Plan Yes]", "[Path].[Pathway Plan].No", "[Service...

I am exporting 2 lists from SharePoint, then running formulas involving fields from both sheets to create reporting, etc. I'm then refreshing the tables in excel to update the data, so the connection needs to stay intact. I'm also using PowerPivot to create a data model to work from with many...

Hi, all of a sudden 4 of my tables wont update. They say "#GETTING DATA". Only if i go into dax and manually refresh will they update. Or if I select the QRY inside excel and refresh the workbook connection. I've tried removing and readding it back to DAX. But still have the same issue? Thanks

Hi, I have 50 DAX tables. I would like to change the order of the tables. But every time I move the tables. They go back to the original order (order of when created). Is there not a way to set the order of the tables? Thanks

Hi, I've created a PowerPivot DAX measure to list my TOP 100 Brands. I would like to find a way to see for the month of May 2019 vs 2018 vs 2017. The measure below shows me each year total compared side by side. I would like to have a slicer control the month. TOP 100 BRANDS:=VAR RankingContext...

Hello Everyone, I herewith posting one example in which I have two tables: 1 Transaction table 2 Range Table <tbody> Transaction Table Range Table Sr. No Product Amount Range Range Start End 1 Pr1 100 ?? 0-100 0 100 2 Pr2 200 ?? 101-200 101 200 3 Pr3 150 ?? 201-300 201 300...

Hi, I'm wondering is it possible to have a power pivot report table that has the details of units sold by one criteria. Then also shows multiple subtotals at the end. IE: Total units sold by Brand is the report. Then I have a subtotals at the bottom listing the season. Another subtotals listing...

<tbody> ItemList Colour1 Colour2 Colour3 Colour4 Colour5 Colour6 Colour7 Colour8 Item 1 Blue Yellow Purple Green Orange Red Cyan White Item 2 Black Magenta Cyan Yellow </tbody> Hi I'm new here so sorry about the unconventional formatting. I have a item table with different coloured...

I am working with an involved PowerPivot data model in Excel 2010. This model has multiple sources of data and numerous pivot tables. Some of the people on the distribution list use Excel 2016 so to make their lives easier, I am providing a "pre-upgraded" workbook for Excel 2016 for them. I...

Hi I have a list of employees coming from my payroll program. Unfortunately the file pulls out each employee and each costing location you can work at. I'm trying to link the employee table to the sales table. But it says both sides have a many. What would be the best way to have a ONE TO...

Hi I have a 100mb Excel file that takes 20 minutes to refresh. I'm wondering if I can delay the updating of the tabs till I select the page. Or have a macro button not to screen update the changes. All my data comes in through power query from a sql database. It's uploaded to powerpivot and...

Hello, Looking for some support regarding the following question. Any SKU that Has05Reason equal to "Yes" AND Has98Reason = Yes then I want to be able to: Return a column and/or measure that says "Yes" the SKU Has05and98Reason Example1: SKU 123 would have "Yes" marked in...

Hi I have a powerpivot formula below. It works, but only with what I've put directly in the formula. Is there a way to have it driven from a slicer or table filter? ONLY LARGE:=IF(CALCULATE([ON HAND + IN TRAN TOTAL],'tblInvSkuMaster'[id_link_2]="SIZE Alpha L/G")=[ON HAND + IN TRAN...

Hi below is some code I've used before. But what I need is a way to refresh a PowerPivot or PowerQuery every hour unit 10pm. I want to pull in our stores sales and have it refresh every hour in the background. Then I want to send out emails. I have that code but need to automate calling the...

Hi I have a Sales power pivot table. And would like to select the Month from slicer 1. And have Slicer 2 with dates only show this month. IE Select July and then it will show all the dates within July. Then I can select July 9 and it will only show that days sales. I need to have one slicer...