Forum Discussion
iMcE
6 years agoNew 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
- AnonymousNot 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.
- iMcENew Member
Anonymous , thnaks for that, good info but not an answer to the question regarding syntax of table1[table2.column]
thanks
Iain.