relationship

Hi All, I'm quite new to Power BI so need someone to hold my hand. I have 3 Tables but no relationships between them, 2 of the tables both have a field ProjID but if I try and match them up I get the message "You cannot create a relationship between these two columns because one of the...

Hi, I seem to have this problem in Excel Pro Plus 2016. Well, I have this problem too for Excel 2013. I think this is probably something simple that I'm missing and I hope you can help me. I can't seemed to make the PowerPivot I've created reflect the many to many relationships correctly...

Dear Team, I am trying to use SAMEPERIODLASTYEAR in CALCULATE. My formula did not work because I cannot have a relationship between the Data Table and the Fact Table. So I was intending to use an inactive relationship and then activate it with the USERELATIONSHIP function, but when I checked...

So I have an issue I am not positive how to solve. I have a pivot table that is created from an OLAP cube that populates that pivot table in a sheet. I do not have access to the actual source tables from that database. There is a field in that database that is not existent, so I want to link...

how can i join table one, which does not have primary key, and second table which does not have foreign key without duplicated data? Thanks a lot, WIll

Hi all I've been maintaining a long-standing Excel performance management template (.xltm) accessed by dozens of users and updating and storing data in multiple MS Access DBs (.accdb) for a while now, but the whole system pre-dates me by some time. As such, I'm not across all the relationships...

I have two tables in an excel workbook: one that is a list of personnel and the other that is a list of projects. The personnel list contains no duplicates and the projects list has a column for POC which matches the entries in the personnel list. The issue I'm having is that when I try to...

Hello, here is what I have <tbody> Case pk 212 1 1212 2 444 1 111 3 </tbody> Table B <tbody> pk category 1 muffin 2 bagel 3 pizza 4 toast </tbody> I created a relationship between them and i know i can go to table A and do related(TableB'category'), the problem is that...

Hi, I'm very new to powerpivot. I am trying to pull data from an analysis services cube. Because I keep getting timeout errors when trying to pull the full data I have divided it into two sections, one which pulls the measures I want at the level I want (Field x Week x Location) and one which...

Hi all, I have two data tables: 1) Production data with column headers: Key, Facility, Line, Time, Output 2) Costs data with column headers: Key, Site, Cost Center, Time, Cost The tables have a common key named obviously as Key. The data looks like this: Key Facility Line Time Output Alpha...

I am just getting started in VBA & have watched about 20 videos. . . my issue is that I can't find anything that explains the basic concept of understanding coding in VBA. Everything I have seen explains single aspects, but doesn't encompass (for example) how the to string together commands & to...

Hello all, I would appreciate any help from you guys who are guru's or anyone else who may have the answer. I am just beginning to learn PowerPivot. I'm hoping that PowerPivot will solve many of the issues I deal with Excel that make me work extra just to do work-arounds. Here's my issue in...

I have a problem that I've not seen any example of how to solve regarding PowerPivot and Pivot Tables. I have 3 tables; stores, visitors and store_competitors. 'stores' looks like this: store_id, store_name 'visitors' looks like this: visitor_id, visited_store_id 'store_competitors' looks...

Greetings! I have a spreadsheet in which I have several sheets, each of which has its own table populated by an SQL query that displays the data per sheet by customer name and then sorts by a status column that is either "open" or "closed" (Open in Descending order) and then sorts by created...