Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

problerms Datediff function

Hi Community,

Can someone tell me where the fault is?

 

 

 

 

 

 

 

 

 

 

Need Help
Tips and Tricks
  • v-xicai's avatar
    v-xicai
    5 years ago

    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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        v-xicai
        Community Support
        5 years ago

        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.