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 Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors