data model

Hi to all I have some tables in the data model where i made some relationships, but i want in my excel to make something like a vlookup based on that relationship in the data model. is there away to do that? all the help would be appreciated. Akasha Walker

I have a desktop PowerBI file created from a PowerPivot model using File | Import. I updated the source Excel file with a new table using PowerQuery and I would like that table to also appear in the PowerBI file. I can't figure out how to do that. If I try File | Import again it blows away my...

Hey Everyone For the last day I've been trying to get my VBA code to add a data field to my pivot table. I'm after a unique count of "Unit Numbers", but I keep getting "subscript out of range" run time error 9. Given it is distinct count, this needs to be added to the data model. I've not...

Good Morning - I am sure this has been discussed on this forum ad nauseum, but I can't seem to find anything on it. I created several Power Queries and added them to the data model. Then I realized I needed to change one of the filters in one of the queries. I thought it should be easy...

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...