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, Robin
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.
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
how to represent the Pivot Chart when the measure count is 0
hi i have scenario where my data model doesn't retrieving any data after the DAX query from cube. so as a results my pivot chart not showing any thing how can i show the text "No data available" for this kind of scenario please advice. My Data model in excel. report
