data model

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

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