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.
Is there any way to lookup values from another table based on the most recent date, without using the LOOKUPVALUE function? I'm creating a calculated column and I'm getting ciruclar dependency error when I use the LOOKUPVALUE function.
This is the code that is giving me circular dependency:
LOOKUPVALUE(Table1[Summary], Table1[ID], MyTable[ID])
Solved! Go to Solution.
@nok Try:
Column =
VAR __ID = [ID]
VAR __Result = MAXX( FILTER( 'Table1', [ID] = __ID ), [Summary] )
RETURN
__Result
Hi,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
@nok Try:
Column =
VAR __ID = [ID]
VAR __Result = MAXX( FILTER( 'Table1', [ID] = __ID ), [Summary] )
RETURN
__Result
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
37 | |
31 | |
26 |
User | Count |
---|---|
96 | |
84 | |
43 | |
40 | |
35 |