sort grid using field from another table

Hi ushah763 ,

To create a calculated column in opportunities table.

newcd =
VAR mindate =
    CALCULATE ( MIN ( Events[Event Date] ), ALL ( Events ) )
RETURN
    IF (
        'opportunities'[CreatedDate] >= mindate,
        'opportunities'[CreatedDate],
        BLANK ()
    )

Please find the pbix as attached.

Regards,

Frank

Hi ushah763 ,

A calculated column is not dynamic. So here we should create a measure to work on it.

Measure = var mindate = SELECTEDVALUE(Events[Event Date])
return
IF(MAX('opportunities'[CreatedDate])>=mindate,1,BLANK())

Please find the pbix as attached.

Regards,

Frank

Hi ushah763 ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank