topic Data Type Comparison in DAX Commands and Tips

Data Type Comparison

Anonymous — Fri, 20 Oct 2023 11:31:03 GMT

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

Re: Data Type Comparison

Dangar332 — Fri, 20 Oct 2023 11:46:59 GMT

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" )

Re: Data Type Comparison

Anonymous — Mon, 23 Oct 2023 06:23:02 GMT

Hi Anonymous ,

Update your dax.

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.