data model

Hi all, Hope all is well Thanks for taking the time to read this. I have recently started with Power BI, previously relying on Microsoft Query to pull data into Excel to manipulate. Looking for any guidance to getting Power BI set up to replace / refresh Microsoft Queries. In principle I...

I recently stumbled across the Data Model tools in Excel 2016 and want to know if I can use it to create a relational database structure in Excel with the data tables setup on the tabs of an Excel workbook. Can anyone point me to a tutorial, textbook or, better yet, an example database that...

there is Date field in the table, when I am making its pivot table with data model, in this pivot, "group" option on date is disable. I really want to group dates on month,, can anybody help?

Good Morning, There is a user who has the Mac version of Excel which doesn't include the option for Distinct Count in Pivot Tables. Is there an alternative method to get the same result? Many thanks in advance

How do I reference a table ("QA_Full") that exists solely in the data model and not on any worksheet? I know how to do it when the table is on a sheet (i.e., Set MyTable = Worksheets("Sheet1").ListObjects("QA_Full")), but how do I accomplish the same thing when the table only exists in the data...

Hi - I'm currently using Excel 2016 Professional Plus. I have a workbook that contains a large data model. I have 20+ reports I need to create and this data model will be used as the repository that supplies all the information for those 20+ reports. However, every site/blog I read (granted...

Normally I search a long time before posting but I have to get to a meeting and if I cannot get this answered now (4pm EST on a Friday afternoon), I cannot finish work planned for this weekend. I would DEEPLY appreciate any help! The research I've found looks like there is no solution from...

Afternoon, I have a pivot table references multiple tables (when creating the pivot table, i chose "add this data to the Data Model"). I have the relationships I need created, but when I go to select calculations to enter a formula and it's grayed out. I have sales data based of months, and...

Hi Everyone, Here's a scenario: I have a spreadsheet of data which I select then click "Insert Pivot Table" and check off the box "Add to Data Model". The result is that I have a new sheet with a pivot table, and a sheet with the source data. I need to add new columns to the source data, so I...

I am working with an involved PowerPivot data model in Excel 2010. This model has multiple sources of data and numerous pivot tables. Some of the people on the distribution list use Excel 2016 so to make their lives easier, I am providing a "pre-upgraded" workbook for Excel 2016 for them. I...

I am working with an involved PowerPivot data model in Excel 2010. This model has multiple sources of data and numerous pivot tables. Some of the people on the distribution list use Excel 2016 so to make their lives easier, I am providing a "pre-upgraded" workbook for Excel 2016 for them. I...

I have about 100,000 row model running in Excel 2016 Pro Plus. Have established a data model with two tables and recently created a Pivot Table from the data model. I needed to filter one of the columns and went back into the Manage PP screen. I was able to successfully filter the column in...

Hi all, I am trying to figure out how to use a calculated measure as part of an equation for another calculated measure... Basically I'm trying to create a calculated measure to calculate the Coefficient of Dispersion (COD). Excel 2016 has this formula built in, but I'm trying to create it in my...

Hi I was doing a lot of cleaning up and fixing in my major excel workbook. In the process i now get and error message can't find the data model. But i don't know where this comes from. Is there a way to track it down? Thanks

HI Guys I have just started getting this error had the file running 4 years with no issue. Error "An issue with the data model is preventing Microsoft excel from opening this workbook" I have tried that several times but it has not fixed it. Anybody any idea on how to trouble shoot this?

Hi, I have generated ODC file (which contains real time data from Dynamics AX) and I would like to add this file to data model. I can get data from .odc file as a table in Excel and if I update connection everything is working, however when I am trying to add this to data model, every time...

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