topic Re: Understanding syntax...LASTDATE(table1[table2.dateColumn]) in DAX Commands and Tips

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

iMcE — Thu, 23 Jan 2020 17:08:26 GMT

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.

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

Anonymous — Thu, 23 Jan 2020 17:23:45 GMT

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.

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

iMcE — Mon, 27 Jan 2020 09:12:14 GMT

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

thanks

Iain.