data model

Hello, Apologies if this is in another thread, I did a search on control chart on the threads with no luck. I am trying to create a pivot table that will provide me with a control chart I am looking at having a data model with calculated fields named "Control Line", "UCL", "LCL" and "Std...

I've come across a strange behaviour of Power Pivot related to measures on fields of detail tables. I have the following simple model: Grades (Grade code, Target Utilization) Team (Name, Grade code) <links to the Grades on Grade Code> Forecast (Name, Period, value, MaxValue) <links to Team on...

When I try to save or modify a pivot table in an open workbook, I keep getting this error message "An issue with the Data Model is preventing Microsoft Excel from opening this workbook. Try restarting Microsoft Excel". I have tried previous versions of the same template that have always worked...

I have a table that shows orders. I have an order number, and open date, and and end date. This has been loaded to the data model as I use Power Pivot (and this table is linked to others.) Within the data model I have a calculated column that calculates the number of days between the open and...

Hello there, I am new working with Excel data models, and I would like to know if is possible to do the following: I have a table that lists elements by boxes. Box type 1 contains elements 1,2,3,4: box type 2 contains elements 2,5,7,9; Box type 3 contains elements 2,4,6: Box type n contains...

Hi, I have a pivot table that was generated by using a power query data model. I have a filter on the pivot table called "EmpName" and I would like to iterate through all the EmpNames in the filter, copy the resulting pivot table data to a new workbook and save it as an entirely new workbook...

Hello everyone, long time no post! I have a situation, which I would think can be solved rather simply, but I can't figure out a way to do it. I have several POS systems and how much they are able to sell. We also have the knowledge of how much volume we do every weekday, every month that...

Hi all, I am fairly new to Power Pivot. I am having some trouble understanding filtering between related tables. I have my main table "Demographics", in which "Index" is Unique so: Index Role 1 Engineer 2 Engineer 3 Manager...

Hi, If I've loaded a table into power pivot , it is then showing in the 'connections' of the queries and connections pane in power query. Is it possible to load these into power query? if yes , how? if no , I can stop trying. RD

Hi Everyone, I am seriously considering spending a lot of time building a data model in order to benefit from Power Pivot and DAX. I work as a finance business partner and my role is to analyse data (monthly most of the time) through multiple scenarios (P&L by country, by account, by project...

Hi all, Using Excel 365. I highlighted my data >> Insert Pivot Table >> Add this Data to Data Model. I added fields to Page Filter, Filtered for a vendor I added document # to Rows and Distinct Count of Type to Values There are 44 Document #'s and the Distinct Count of Type for each Document...

I have created some code that created a data model based pivot table that just displays a type, qty and concatenated string built from a column of references. This all works fine on the first run. Where it goes wrong is if I run it again on the same worksheet, even defining a different range, it...

My organisation is trying to implement a Live Connection (Data Model?) into our area. As a report developer, it seems very limiting and not what a report developer should be doing. No Data Transformation through Power Query Editor nor the ability to form and understand Relationships seems like...

Hi I'm trying to learn how to use the data model effectively and I'm fairly confident in the basics of importing tables and joining them, adding columns etc. I'm struggling to understand how I can deal with things that change over time. I'm trying to solve the following problem using a data...

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 - Thank you in advance for the help. I'm working on a sales runbook that combines actual and pipeline data to get to a forecast for the quarter. The sales leaders need to be able to determine, at a specific opportunity level, if an opportunity is going to close this quarter or not. If it...

I have several tables (different data) in my Excel data model and I want to JOIN them with a manual sql query. Is it possible ? If it is, how to do it ?

Whenever I press Enter to start a new line it returns me back to Edit Table Properties. Is it a normal thing ? Is there a way to use Enter as a new line command ? na

I need advice on the best general approach to creating, maintaining, and synchronizing a shared data model across multiple platforms: Excel with Power Pivot/Query, Power BI, and Power BI Desktop. Most source data are from an ERP cloud (CostPoint), so much of the model is implicitly defined...

I have 3 pivot charts each with their own data source. The tables are all set up the exact same way. They have the exact same layout, just different numbers whether it's referencing a 6 month, 12 month, or 2 year projection. What I am trying to accomplish is I have all 3 pivot charts displayed...