Forum Discussion
Where and how do I create a calculated column using fields from different tables
Dear Power BI community I have looked through various posts but cannot find an answer which resolves my issue I would like to know where and how I create a calculated column which finds the d...
amitchandak
Super User
Super Userhelen_p , Expected output is not clear
You can create a new column Table 1 and Table 3 like
Start Date in Table 1 = max(filter(Table3, Table3[ID] = Table1[ID]), Table3[Start Date])
Transaction Date in Table 3 = max(filter(Table1, Table3[ID] = Table1[ID]), 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