Forum Discussion
problerms Datediff function
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.
Internal and confidential content is permitted. Translate unfortunately it doesn't work for me. can you please show me this with a concrete besipiel?
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.