Forum Discussion
Use Single Processing Date for Calculations
Anonymous , Is there relation between two table or a common column ?
if not try like
a new column in table 1
= datediff([date registered], max(Table[System Processing Date]), day)
if there is a common column, get the value first, refer to these methods
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
Anonymous , Is there relation between two table or a common column ?
if not try like
a new column in table 1
= datediff([date registered], max(Table[System Processing Date]), day)
if there is a common column, get the value first, refer to these methods
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
Thanks! using the Max function worked!