Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sovereignauto
Helper III
Helper III

First Record

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 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super 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])

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super 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! 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.