cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
davidoz
Frequent Visitor

Lookup another column in the same table

I am building a dashboard which shows the schedule of some equipment

 

The raw data comes in this format:

TABLE.png

 

As part of the dashboard, I created this matrix below which shows the type of unit, and when it is next booked.

MATRIX.PNG

 

The NEXT DATE measure = min(date). Which basically shows the user the next date the equipment is booked. I also want to show the base where it is booked next. Basically looking up the Base column from the NEXT DATE measure. Does anybody know how to do this? I am at a bit of a dead end unfortunately because I can't figure out a way to lookup to another column on the same table.

 

If it helps, there is always one line per unit per day

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @davidoz 

please try

=
VAR NextDate = [Next Date]
RETURN
    MAXX ( FILTER ( TableName, TableName[Date] = NextDate ), TableName[Base] )

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @davidoz 

please try

=
VAR NextDate = [Next Date]
RETURN
    MAXX ( FILTER ( TableName, TableName[Date] = NextDate ), TableName[Base] )
davidoz
Frequent Visitor

thank you! this worked great!

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors