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
Community Champion
Community Champion

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
Community Champion
Community Champion

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
August 1 episode 9_no_dates 768x460.jpg

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 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors