Forum Discussion
Date Hierarchy/Dax Function
Hi Everyone, I have a date column in table A called Transaction Date, when I'm working on Table B ( I have already stated the relationship between both tables by customer number), and I try to write...
amitchandak
Super User
Super UserAnonymous , try
year(related(Table1[Transaction Date]))
or
year(maxx(relatedtable(Table1),Table1[Transaction Date]) )
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8