Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
In power Project there are two table
Table Base_1 couloumn Home ( H1,H2,H3), Student ( S1,S1,S1,...)
Table Base_2 Action ( A1,A2,A3), Room(R1,R1,R1), Student( S1,S2,S3...)
The objectif is to have SQL or Dax commande to :
Create new table 3 based on two imported one and the condition is :
When for example on Base_1 The Home=H1 the New table base_3 will be with Value of Base_2 / Student=S1 because on Base_1 when Home =H1 Student=S1 so will take on Base_2 value Student=1 and other data Action A1...
Table Base_1
Home Student
H1 S1
H2 S2
H3 S3
Table Base_2
Action ( A1,A2,A3
Room(R1,R1,R1
Student( S1,S2,S3
I assume there will be multiple actions per student, and the 1:1 relationship you show ins not supported with larger data sets? Please provide more realistic sample data in usable format and show the expected outcome.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |