Forum Discussion
Data Type Comparison
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 >= dt4wk , "2wk" )
This is my code (i will add the other variables at the end) but wanted to fix this first! so using this i get the "DAX comparison operations do not support comparing values of type True/False with values of type Date. Consider using the VALUE or FORMAT function to convert one of the values." error. How can i fix this? ive used values and INT but must be doing something wrong.
And how can i use switch in this? thank you
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.
2 Replies
hi, Anonymous
use convert function like below
wk_col_FILTER = VAR dtToday = TODAY() VAR dt2wk = convert(TODAY() - 14,datetime) VAR dt4wk = convert(TODAY() - 28,datetime) VAR dt26wk = convert(TODAY() - 182,datetime) VAR dt52wk = convert(TODAY() - 364,datetime) VAR dt1yrplus = MIN('OTIF - OPD'[Original Promise Date]) RETURN IF('OTIF - OPD'[Original Promise Date] <= dtToday >= dt4wk , "2wk" )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.
