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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
iMcE
New Member

Understanding syntax...LASTDATE(table1[table2.dateColumn])

Hi all, newbie learning...
I've been trying to use the reference docs. to fully understand the syntax of the table1[table2.datecolumn], used in a CALCULATE filter, but cannot find any reference to this syntax - it is always 'table1'[columnName] in the ref docs...

I can see what it does but not why it does it which makes me nervous...

 

Any pointers would be much appreciated.

 

Thanks

Iain.

 

 

2 REPLIES 2
Anonymous
Not applicable

for better understanding

read this article

https://www.sqlbi.com/daxpuzzle/last-date/

 

Thanks

Pravin

 

if it resolves your problem mark it as a solution and give kudos.

@Anonymous , thnaks for that, good info but not an answer to the question regarding syntax of table1[table2.column]

 

thanks

Iain.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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