relationship link tables

Hi everyone, I need to calculate the sum of a column quantity to Article material in Table 3 for each product material in Table 1, column A when Group in table 2 equals Group in table 3 Example: sum of (material article 2000) = 80+60+45+150 in table 3 (4 rows highlighted with color, excluding...

Hi all I need some assistance please, I have a dashboard, where I have a date slicer, which is filtering fine on tables with a date, however, I have a staff list table which doesn't have a date to create a relationship with, but I am using the staff table in order to calculate how many people...

I have just started using Power BI. I have created below tables: 1. Date Table 2. Purchase Table 3. Sales Table 4. Purchase Return Table 5. Sales Return Table 6. Scrap Table All tables are having a field of "Date". I want relationship of Date Table with ALL other tables as "Date" field is...

Hello there everyone! So I'm in process of creating a new database for use at work that will manage and keep track of our tooling kits. i have a pretty good idea on what tables I'll need and how they're connected except for one thing. basically the main table i want is my kitting table...

Hi I'm trying to join two tables together through a relationship but am having trouble. My data is of a Building (type text) , which has Floors and Rooms which can both be a mix of text and number names (type any). In order to create a relationship based on the Room column, I attempted...

We have 300 employes in our company. I want to make attendance sheet. Which record everyday employee activity like he is working on base or outdoor location.. I can make simple table for each employee name in one column, but i am not understanding how i assigne each day... I also want to...

Hello, I have a pivot table set out as below, with the dates grouped by Month, Qtr and Year. The pivot table is linked from 2 data sources <tbody> QTR4 OCT NOV DEC FC AC %DIFF FC AC %DIFF FC AC %DIF APPLE 100 110 10% 50 100 100% 70 50 -29% ORANGE 20 40 100% 20 20 0%...

Hi experts, I just start to use this awesome wonder called PowerPivot. I've been a regular user of Pivot Table. I am not sure if my question is a simple one. Here it goes. I have two Lookup Tables: Date Table and Factory Table (only consist of factory codes and their corresponding names). In the...

Hi Everyone, I have two tables, One is Budget Table and another is Expense Table. In both the tables there are two columns which are common. One is "Quarter" and another is "Budget" Column. I want to create relationship between both the tables and create a Power BI dashboard with these two...

I have an assignment where I need to design a database with special instructions. Within the db design are 2 tables: one table (Purchase Orders) with 2 primary fields identified (Purchase number and Computer Part #), the second Table is the Cash Disbursements Table that has Purchase number as a...