Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!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.
I am building a dashboard which shows the schedule of some equipment
The raw data comes in this format:
As part of the dashboard, I created this matrix below which shows the type of unit, and when it is next booked.
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
Solved! Go to Solution.
Hi @davidoz
please try
=
VAR NextDate = [Next Date]
RETURN
MAXX ( FILTER ( TableName, TableName[Date] = NextDate ), TableName[Base] )
Hi @davidoz
please try
=
VAR NextDate = [Next Date]
RETURN
MAXX ( FILTER ( TableName, TableName[Date] = NextDate ), TableName[Base] )
thank you! this worked great!
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
73 | |
70 | |
67 | |
44 | |
41 |
User | Count |
---|---|
48 | |
42 | |
29 | |
28 | |
27 |