Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I would like a measure that displays the last note (based on date column) in a relatedtable. And only on the first level in the matrix...im guessing some use of ISINSCOPE('Company'[CompanyName])
@Anonymous Maybe:
Measure =
IF(
ISINSCOPE('Company'[CompanyName]),
VAR __Date = MAX('Notes'[Date])
RETURN
MAXX(FILTER('Notes',[Date]=__Date),[Note]),
BLANK()
)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |