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] )

thank you! this worked great!

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors