model

Hi I am looking for a VBA to open a workbook (FX rate log) from a specific file path and the look for a specific date (Today()-1) and copy the rows including the date and various currency rates to another workbook (Working model) within worksheet (FX Rate). Data layout in FX Rate log –...

I changed the column order on my query and when it loads to the data model the columns are in the original order. My expectation was that I you change the query it's reflected in the data model. Help!

I have a table that was loaded in a data model. Now I would like to add some more lines to it, by pasting data in the excel table (resize the table range) and when I refresh to add to data, this new data disappears. I would like to avoid queries as this excel is very complicated already. Thanks

Hello, I want to create a data model based using two Excel workbooks, then I want to save the data model and use it in other workbooks. Basically, I want to be able to add measures, columns, tables, relationships, etc. in the future and have all my workbooks using that data model reflect the...

I have prepared a measure that returns a certain rate determined to be calculated only within a certain part. But then when I call this measure, only blank is returned, even though the measure shows a number. I have prepared a condensed example Power Pivot model that explains what needs to be...

Hi Sorry if this off topics. I am reading the job description below. I would appreciate if you can answer my questions just to get an idea what is the requirement and where I am at. 1) Validate MS Access databases to align with current excel model My question: Is this Access, Excel or VBA...

I am looking for help on how to import text file data based on the files page break. My current VBA is below and writes the data to Excel, but does not do it by page &/or dealer. Any help is appreciated (text file example follows code). Option Base 1 Dim TextLine As String Dim FileToOpen...

I'm not very strong at VBA and the conditional formatting is based on a lookup value being greater than the value in column B. I would like the code to run anytime that the value in column B is updated. So I'm creating a model and each row will be an employee - column B is the employee's start...

Hi all, I have a Data Model with a couple million rows. I can't load this as a worksheet in Excel 2013, so i've converted this into a data model. I want to be able to easily filter through my data and return relevant results, ideally with the help of Slicers. How can I input my Data model...

Hi all, having issues with excel VBA and any input for this will be much appreciated. i have searched existing threads and not able to find the fix for this issue. here are the issues : 1 After saving the model, the macro run would fail, with error message below: Run-time error...

If this question has been asked before, then I apologise, I have been searching through forums for more than a year now. This is also my first post. I have created an Add-in which is accessed from the ribbon loading a Userform. All the code of all the things done by the Userform is located in...

For context I am trying to hide tabs based upon the specified user of my model and I want to make it dynamic such that if new tabs were to come into the model....all I would have to do is say if it were true or false based upon the specified user. I have 5 different users lets call them...

Hello and thank you in advance if you can help, I am using MS Office 2019 on a PC. I am somewhat new to Power Query and Power Pivot, and I am trying to analyze a data set in a way that as much of it as possible is "automatic". I currently have to run multiple pivot tables and bring information...

Hello, I am trying to pull certain data from a raw data file that is updated weekly from another source and place it in a more presentable model. I am having to use multiple criteria (Columns A and B below) to try and get the appropriate lookup value from Column C through F but am not having...

<tbody> WW12 WW13 WW14 WW15 WW16 WW17 WW18 WW19 Model A 10 15 5 20 15 50 10 5 Model B 20 5 5 20 15 10 15 5 Part 1 30 20 10 40 30 60 25 10 Model C 5 1 2 1 10 5 5 5 Model D 5 1 1 1 1 1 1 1 Part 2 10 2 3 2 11 6 6 6...

i did this years ago, but cant replicate what i did. I have Table1 and Table2 and with a relationship of Column1 = Column1. there is only one column in table1 and two columns in table 2. All i want to do is bring in the value in Column2, called junk, into Table1. There are 500,000 rows in...

Hi I have a data model in SSAS. I can connect to it happily using 'live connection'. I see all the tables, and their relationships appear to be in place (I can't see this directly in 'live' mode of course, but reports join as expected). However, if I try to load some of the tables in 'import'...

Hi guys, I'm really struggling to get this to filter as I wish using CALCULATE. Can anyone help with correct DAX, or offer any alternative methods of achieving this in Power Pivot? The relevant fields in my dataset are: SiteID, AssessmentDate, Grade. I only want my model to to filter for the...

I have been experiencing this same crash on multiple files... it seems like an excel glitch. It happens when I have data loaded into the data model via power query and pivot tables feeding from the data model. When I execute the freeze pains shortcut (Alt, W, F, F) the file immediately crashes...

I run some analysis that's fairly heavy. And one part involves getting unique instances of a customer where distinct data field would help. However Data Model seems to be really CPU time consuming. Since I know there are never really more than about 50 unique instance per customer per daily...