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 Team,
Need your assistance here please.
I have the complete database of test results in Table 1, the students might have done the test mutiple times at different time stamps (Enddate column shows the date the test was done & Marks column has thier scores).
In table 2 I have the complete list of students. I want to add 2 columns in Table 2 and want to get the latest date from table 1 Enddate column and the Marks they have scored on that date.
Thanks in advance.
@KiranR , a new column in table2
End Date = maxx(filter(Table1, Table1[tg_id] = Table2[tgid]), Table1[enddate])
Marks = maxx(filter(Table1, Table1[tg_id] = Table2[tgid] && Table1[enddate] = Table1[End Date]) , Table1[Marks])
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |