data model

hi folks, I am trying to solve trailer load allocation planning.This would have been easier if i had w*h*d in my data set, but i have a combination of products for a particular trailer type.And i have multiple dealers/destination spreaded across the region. Have attached below a scenario which...

Hi, can you help me to established this query? i don't know what i'm doing wrong. i only use only create connection & add this data to data model. this since i'll going with millions of datas here's my data looks : remarks column : will be filled either blanks or with text/string Date...

I watched the YouTube Video - Budget vs. Actual - Podcast 2016 where a data model is used to compare an actuals table to a pivot table, by using intermediary "Joiner tables." It's a great solution! I am trying to expand the idea by introducing a calculated column for the difference between...

Hello, Daily i need to check if a number of values exists in a database. That database if available through a link, which i imported to excel to a querie and then to a worksheet. The problem is, now the report exceeded the number of lines in excel and i can't accurately verify if those numbers...

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