Target file ready for data modelling
Hello, I have a monthly target file which contains, brand wise target and customer wise target. I have file in following order. customer Name Brand total_target january_target february_target ... Customer_A Brand A 100000 5000 Customer_A Brand B 120000 2000 How can I change my target file so that I can model this target to the transaction table thank you!
Wrong Filter Flow Direction when using Excel Power Pivot
Hello everyone! I am having a problem which is doing my head in. So in the file attached, you can see that I have a table for Package, a table for Arenas (Products), and a table of which arenas belong to which Packages. An Arena can belong to 1 or many Packages and a Package can include 1 or many Arenas, therefore I created a table between them where you simply add this information. Now, I want to see which arenas belong to which Packages but the filter direction goes in the "wrong way". I want to be able to filter the Package table and see which arenas that belong to that package but as you can see, I get that all arenas are included in all packages (because of the filter direction). If this was Power BI, I would change the direction of the relationship to "both" but this does not seem to be a function in Excel Power Pivot. I need help 🙂 Kind Regards, Kind Regards, RobinPower Pivot add in lost 2019HB
Power Pivot does not work in Excel. I tried to activate it as an add-on but it does not appear available. I looked in the Windows registry and nothing appears. I have Office 2019 HB installed so it should appear. The Power Pivot icon appears on the Data tab, but when you give it, it doesn't open any snow tabs or do any action. Just deploy the help that indicates what I've done, check com plugins and log
Excel PowerPivot - Show Details of Filtered Grand Total
Hi all, I've been testing how PowerPivot can help run daily tasks more efficiently yet still offer the raw data. The current setup pulls data from SQL, into PowerPivot, into a pivot table. When trying to 'Show Details' or 'Drill Down' the raw data from the filtered grand total, the following error message appears. When using standard Excel without PowerPivot, the error message does not appear and I can still access the raw data. The current Pivot Table setup includes a column field which is filtered. Are there any known workarounds or solutions? PowerPivot appears to solve the majority of my issues, however without the raw data it deems useless to my use-case.
Audit PowerPivot and PerformancePoint - are they being used?
Hi, I am doing an audit of SP2013 environment. I can see the service applications and configuration for PowerPivot and PerfPoint are all set but I need to understand if they are being used at all. My understanding is that you can have data connections (e.g. from Excel) to external databases and display the results/dashboards in SharePoint. Is there a way to find if those services are being used? e.g. do I need to find specific files like data sources or data connections? what type of files would I need to look for? Any other tip welcome
Testing for (blank) formula result -- different from ISBLANK() -- missing in Power Pivot data model
Ouput from Power Pivot pivot table is giving the cell value (blank). I'd like to test for this result. However, for example, ISBLANK(+P4) returns FALSE, and of course so does ISBLANK(+O4). How could I flag that the (blank) cell has been created in my pivot table (using power pivot Excel 2019)? The blanks come from a data model with a relationship between two tables when there are legitimate blanks (no data) in the keys used to join the tables. Thanks
