Data Type Comparison

Hi Anonymous ,

Update your dax.

wk_col_FILTER = 

VAR dtToday = TODAY()
VAR dt2wk = TODAY() - 14
VAR dt4wk = TODAY() - 28
VAR dt26wk = TODAY() - 182
VAR dt52wk = TODAY() - 364
VAR dt1yrplus = MIN('OTIF - OPD'[Original Promise Date])

RETURN

IF('OTIF - OPD'[Original Promise Date] <= dtToday && 'OTIF - OPD'[Original Promise Date] >= dt4wk , "2wk" )

Best Regards,

Neeko Tang

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