Forum Discussion
Solved
Status change based on a date from a different table
Hi everyone. I have the first 3 columns of this table: and I want to add the 4th column based on this table: Using a Measure would also work for me, if that is a better way to do it. ...
you can try to create a column
Column =
var _ud = maxx(FILTER('Table (2)','Table'[Unit]='Table (2)'[Unit]),'Table (2)'[Upgrade Date])
return if('Table'[Date]>=_ud && not(ISBLANK(_ud)),"Y")
pls see the attachment below
