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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

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
May PBI 25 Carousel

Power BI Monthly Update - May 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.