Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have 3 tables connected using the same ID number. One contains the Age, one contains a score attributed to each ID, and the third a status of their work.
I would like to have a column that will have an outcome for each ID based on all 3 tables. Say for instance:
if (Table1. Age >18 and Table2.Score > 60 and Table3.Status = xyz) then "Subgroup 1", else if ....
I tried doing this in M (Advanced editor) but the condition applies only to the Source, and looks like I can't have more than one source to have a calculated column. Unless there is a way and I dont know it.
Table 1
ID Age
Table 2
ID Score
Table 3
ID Status
Is there a way I could have it in a column or measure?
Hi,
If you have relationships between the tables, on the ID column in your case, you can use RELATED() to get related values from another table. If there is no relationship you can work around it by using LOOKUPVALUE() to get a value from another table, by looking up the ID.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |