data model

I have a table that has a primary key that is common in several other tables. The "WBS" table has the primary key of "WBS Code" which is related to a WBS foreign key in many other tables (Estimates, commitments, Time Phased Data, progress, etc...) I having trouble getting the model to see the...

I keep getting the following error when I try to refresh a pivot table (not Power Pivot). "We couldn't get data from the Data Model. Object reference not set to an instance of an object". I tried re-selecting the data source, but would get the same error message. I checked to see that I have...

When I create a pivot table, the default setting in the box “Add this data to the Data Model” was checked. The consequence is that creating calculated field (and items) and grouping is disabled. I have now changed the default setting. My problem is that I have many pivot tables (mostly by...

My current formula is below with an explanation of my data: Would it be possible to write this in DAX? =IFERROR(VLOOKUP(K2,K3:M40000,IF($M:$M=0,2,3),FALSE),"01/01/2010") Column K = A Unique Value i.e Product 1, Product 2, Product 3 etc….. Column L = Dates in order of newest to oldest Column M...

Hi everyone, I need some ideas in how to work pivot tables to show what I want. I an working on a dashboard in which I separated the calculations in month to date and year to date. After that i organized the pivot tables to show just the results. The deal is i dont want to create two sheets for...

Hello, I have been using pivot tables w/ data models for a long time, but suddenly my pivot is no longer pulling in data from all line items. When I use the exact same data range for two otherwise identical pivot tables (on with and one without a data model), the line count is significantly...

I use Office 2013, and often create pivot tables that require I check off the "Add this data to the Data Model" box when selecting the data range. I know that this can only be done in an excel workbook (and not a CSV, etc.) and have never had an issue building this table before. Suddenly, every...

Here it the thing. I have workbook that connected to SharePoint lists and file and intended to end-user. Data flow from SP goes to hidden sheets (very hidden via VBA). Then kicks in some modeling and transformation and data loaded to Data Model (Pivot table) only clean and what allowed to see...

Has anyone seen this? I'm not even sure where to start troubleshooting. The 'AttributeRelationship' with 'AttributeID' = 'Week Start Date (Month Index)' doesn't exist in the collection.

I have created a dashboard that has several graphs incorporated. I would like to add one slicer that I can connect to all of the graphs. I have gone into connections in the past and added the different graphs but with this current dashboards I haven't added the pivot tables to the data model so...

Hi All, I have searched the forums far and wide to try and find a solution but have come up empty. I am currently using PowerQuery to bring in some SQL data, perform some transforms and then load it into a data model using Power Pivot. I have created some custom columns to do some calculations...

I have made the most simple of pivot tables simply so that I can use all the fields with another one in a powerpivot but keep getting this error message: 'The selected range is invalid. Select a valid range. A table cannot overlap a range that contains a PivotTable report, query results...

hello everyone, i have a huge problem and i hope you can help. i'm using excel 2013 and i bulit a very big excel that has about 20 pivot tables. when i built them i used the "add this data to Data Model" option and now i send this file to a client for him to use. the client is using excel...

Hello all, I have trawled the internet (including this forum) for a solution I could not find. Sorry if it's buried somewhere in the forums here and I simply wasn't thorough enough. I've been working on three different workbooks that build out a model R.data -> PQ -> PP -> dashboards. All were...

Hi I want to set a pivottable and also use the DataModel feature (Excel 2013) If I record the VBA I get the code I need however it is set to the specific sheet Sub Macro4()' ' Macro4 Macro ' ' Workbooks("April 2015 - orderDATA.xlsx").Connections.Add2 _...

Hello, I have two tables in Excel 2013: Actual & Forecast. Both tables have the following similar columns: Period, Account, Amount. I've included them in a Pivot Table Data Model and would like to calculate a variance between Actual[Amount] and Forecast[Amount]. I'm unable to utilize the...

Hello, I am trying to setup a data architecture for VBA based business simulator. There will be more devs in few weeks but for now I am the lead, tasked with initial project setup. General question is: what would you advice for a definition of custom class, holding a public array of variable...

Hello all. I have a staff list with unique IDs. Each staff member can be a team member, a team leader or a supervisor. To make it slightly more complicated, an individual can be a member of one team and a leader for another – but let’s park that for now. </SPAN> I need to produce a team sheet...

Hello everyone. I’m creating a simple management tool for a number of teams in the form of a standalone Excel 2013 workbook for each team leader, working on a standalone PC. The tool comprises three tables, each on a separate worksheet. These tables are added to the data model and used as...

Hi all, i am creating data connections between excel files in order to import tables of data from one file to the next. I have been successful so far at importing and refreshing such imported tables. however, one of my source tables is quite large and i do not need all of the fields each time...