Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Afternoon,
So i have 1 table:
ID - DateTime - User - Type - Ref
and a 2nd table:
Ref - ( plus lots of columns)
what i need to do is return the "user" from Table1 as a column in Table2 where Ref = "Ref" AND Type = "AACN" AND is the Earliest from the DateTime column, there can be multiple records with the same ref in Table1
Solved! Go to Solution.
@sovereignauto , Try a new column in table 2 like
new column =
var _min = Minx(filter(Table1, Table1[ref] = Table2[ref] && Table1[Type] = "AACN"), Table1[DateTime])
return
Maxx(filter(Table1, Table1[ref] = Table2[ref] && Table1[Type] = "AACN" && Table1[DateTime] =_min), Table1[user])
@sovereignauto , Try a new column in table 2 like
new column =
var _min = Minx(filter(Table1, Table1[ref] = Table2[ref] && Table1[Type] = "AACN"), Table1[DateTime])
return
Maxx(filter(Table1, Table1[ref] = Table2[ref] && Table1[Type] = "AACN" && Table1[DateTime] =_min), Table1[user])
Amazing Thank you!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
108 | |
108 | |
93 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |