relationships

Hi everyone, This one is hard to explain, but it seems like my relationships are not working correctly in Powerpivot. I have 3 tables in my Excel file which I made changes to in Power Query. From 1 table I made a another custom query which removed all duplicates and only gets the unique...

Hi, let me start by saying I don't know much about excel. I don't work with it regularly but I was asked to try and figure something out for my boss. I have exported data from two separate sources, there is very little in common between the two except for the customer names and the amounts...

I have problems creating the appropriate relationship and consequently cannot display my data as I want to. I have the following tables with lots of data created from csv. It is very hard to alter these files as they come in ready. table 1 Calendar table: full-Date, day, month, year, ... table...

i have 2 Table RM Table AM Table Relationship My problem is Must Be show Region Name > RM Name EN >AM Name EN Bkk+CW > Somsak Wattanasanasena > Chaowalit Siriketgon but it show all list in AM Table Answer

Hello there, I haven't used PowerPivot in two years and I am having a hard time with what should be a simple task... I have two tables and I have connected them with a key. One table has a unique key for each record, one table can have several records for a single key. I am trying to add a...

Hello All, I am new to Access, and I am starting to figure things out, working up to designing a database for my company. I am wondering if I am going in the right direction, or if it is plainly obvious to someone more experienced, that I will have problems down the road. Here is a screenshot...

Hi Everyone, Just starting out with Power BI and I have a question. I've got a large amount of data in a large number of tables in Excel which I've imported into Power BI. All these tables have a time column and another column that contains values for a specific measure. All these time values...

Hello, I am developing a database in PowerPivot and I am wondering how to create many relationships between the same 2 tables. All relationships must be active. Let me give you a DUMMY example: let's say that the database has 2 tables, the Employee table and Manager table (below images)...

If I have two fields in a primary table that relate back a country code lookup table, such as Origin_Country and Destination_Country and I would like to look up the country name for Origin_Country and Destination_Country for use in PivotTables, is there any way to create the equivalent of an...

I would like to ask about a problem concerning the usage of pivot tables with defined ralationships between tables (I use Excel 2010 with PowerPivot) . I’ve got a classical figure of relationship one to many. Table1 with static dimensions of an object and table2 with dynamic structure for events...

I have 5 data tables that all contain a roster with the same last names, but with different types of data. I have added each data table to the Data Model. Each time I try to combine one person's data from Table A with Table B, Excel prompts me to create a relationship. I've tried creating a...

Hello all. I have a staff list with unique IDs. Each staff member can be a team member, a team leader or a supervisor. To make it slightly more complicated, an individual can be a member of one team and a leader for another – but let’s park that for now. </SPAN> I need to produce a team sheet...

I'm quite confident with Excel but a complete newbie when it comes to BI and now I'd like to add the BI tools to my set of skills as well. I can understand the basic relationships between the tables but I'm lost when I have more than a single column in my facts table that are all related to the...

Hi, I am using Excel 2010 with PowerPivot add-in, very much a newbie in Power Pivots. I have a set of shipment data compiled from various sources. They have to be cleaned and grouped into lanes. For the purpose of cleaning the origin and destination points I have a list of all variations of...

Hi I have 2 tables as per below, table 1 has the exact people i require in it but table 2 has an extra bit of detail i need to pull in. Currently i have created 2 relationship from table 1 to table 2 (firstName - ChristianName) and (Surname - SecondName). these are on a include all records from...

Hello, I want to be able to join 4 tables using a timekeeper ID as the bridge/commonality between all 4. Table 1 TK ID Multiple rows of Fees for each TK ID Table 2 TK ID Multiple rows of Costs for each TK ID Table 3 TK ID Status (Approved, Not Approved) - only 1 status for each TK ID Table...

I building a database to practice my excel skills and I have compiled three small excel tables which I am going to expand once I get the basic structure and calculations working. I'm also simplifying things just to make it easier to understand my problem. I think the formulas are going to end up...

I am struggeling to make a relationship between these two tables in Access 2010. To get the same value of the column on the first table I need to concentate two colums of the other one. I have two tables. Table "Orders" "FirstnameSurname" "John Smith" "Tom Jensen" Table "Costs"...

My fact "sales" table contains transactions between 01/01/2011 and 06/30/2014. My date table contains consecutive dates from year 1998 to 2017. When I use year column from date table in a slicer all the year numbers prior to 2011 and after 2014 are displayed "greyed out" on the slicer. I will...

I have two tables, one has the [Sales data] (Customer and Sales Dollars), the other table has [Order Details] (Product line and SKU). Both are related with a 1:1 key. I want a pivot report to show Customer (from sales) in the column, SKU (from orders) in the next column, and Product line...