problerms Datediff function

[Anonymous]

Hi Community,

Can someone tell me where the fault is?

[amitchandak]

@Anonymous , if it a measure. Then you need to min or Max on the date from your table

[Anonymous]

Internal and confidential content is permitted. Translate  unfortunately it doesn't work for me. can you please show me this with a concrete besipiel?

@amitchandak

[v-xicai · Accepted solution]

Hi @Anonymous ,

If you need measure to create [Status], then try codes below.

Status=

VAR _m=DATEDIFF(TODAY(), MAX('MB final'[Custom.1]),MONTH)

RETURN

SWITCH(TRUE(),

_m=0, "1.On Time",

_m>0&&_m<=3, "2.delayed 1-3 month",

_m>3&&_m<=6,"3.delayed 3-6 month",

"4.delayed >6 month"

)

If you need calculated column to create [Status], then try codes below.

Status=

VAR _m=DATEDIFF(TODAY(), 'MB final'[Custom.1],MONTH)

RETURN

SWITCH(TRUE(),

_m=0, "1.On Time",

_m>0&&_m<=3, "2.delayed 1-3 month",

_m>3&&_m<=6,"3.delayed 3-6 month",

"4.delayed >6 month"

)

Best Regards,

Amy 

Community Support Team _ Amy

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