Difference between two values in which one from Date column and another from measure date

Hi  Anonmous_user ,

Here are the steps you can follow：

1. Create measure.

Dim_select =
MAXX(ALLSELECTED('Dimtable'),[Date])

Measure =
DATEDIFF(
    MAX('mytable'[Create date]), [Dim_select] ,DAY)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly