datamodel

I appreciate this forum for helping I need help in combining data from two tables into a Pivot table in Excel My data are like given below Table 1 that stores the stops between a start and end. Table 2 that stores how much load was transferred between start and end. I wanted to combine these...

Hi, I am hoping one of you fine people can assist, I am using VBA with a data model to draw Pivot Tables (the data is loaded to PowerQuery Only and saved as a connection). Drawing the Pivots was fine once i got my head around the nuances of CubeFields with the help of trusty WiseOwl videos...

Hello All - I have a year-to-date sales sheet with total sales in four currencies: CAD, USD, GBP and EUR. The sales table has been loaded to the Data Model, and a relationship to the Calendar Table created so that specific month sales pivot table displays values according to a Timeline...

Hi lovely People! I'm trying to update my power pivot data model to keep a table with my measures but change a Power Pivot Data Connection to a Power Query Data Connection. Using Power Pivot Data Model Connections in my WorkbookDataModel.xlsx This is my table: When trying to edit to get...

Hey guys, I am currently trying to build a database in Excel that contains all Green Climate Fund (GCF) projects. Recently the GCF published an API that allows internet users to access their project data through the following URL: https://api.gcfund.org/v1/projects. I used the "Get Data from...

Excel 2016 I have a DataModel that is fed from 9 Excel tables (notPowerQuery). I use VBA to run SQLqueries and dump the results into these 9 tables and then refresh the DataModelwith Thisworkbook.Model.Refresh. However, not all the tables refresh their data and am at a lossas to how to...

Hi, Is there a way to refer to a table imported (connection only) in the datamodel of the workbook for a lookup or a dropdown for example. Something like CUBEMEMBER("ThisWorkbookDataModel";"[Table1].[Column1].[All]")<strike></strike> maybe?

Hi, Apologies if this is the incorrect forum. I'm trying to add bounds and units to the category axis of a pivotchart populated with a series of dates. The Format Axis dialogue recognises that the Axis Type is a date but no Bounds or Units boxes are shown. This only seems to occur if the dates...

My understanding is that in Excel 2016 if you keep the focus on the datamodel the workbook pivots should NOT refresh. However my model refreshes pretty much ever time I enter anything in the datamodel which is making it extremely tiresome trying to build out the formulae. Is there some setting I...

Hello forum users, I am a Power Pivot beginner and I created the following data model: Contained in the following Excel: Example excel file The tables productParts, productList and productProduction contain data. Now I am trying to create the partProduction table that contains for each...