Forum Discussion

giovanni_figuei's avatar
giovanni_figuei
Frequent Visitor
4 years ago
Solved

Show a Text based on a Date

Hi. I need to show a text based on a Date but i can't think of a way to do that. Heres the situation: I have a ID code wich have a lifetime, based on this life time i want to display a text inform...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, giovanni_figuei 

     

    Please check the following methods.

    Measure = 
VAR N1 =
    SWITCH (
        TRUE (),
        SELECTEDVALUE ( 'Table'[Date] ) >= DATE ( 2020, 4, 15 )
            && SELECTEDVALUE ( 'Table'[Date] ) <= DATE ( 2022, 12, 31 ), "VALID",
        SELECTEDVALUE ( 'Table'[Date] ) < DATE ( 2020, 4, 15 ), "INVALID",
        SELECTEDVALUE ( 'Table'[Date] ) > DATE ( 2022, 12, 31 ), "INVALID"
    )
RETURN
    N1

    If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

     

    Best Regards,

    Charlotte Zhang

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

     

     

     

giovanni_figuei's avatar
giovanni_figuei
Frequent Visitor
4 years ago

I was thinking something with this logic :
IF (date of today)>(end date)
then (display "INVALID")
IF (Date of today)<(end date)
then (display "Valid")

 

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, giovanni_figuei 

 

Please check the following methods.

Measure = 
VAR N1 =
    SWITCH (
        TRUE (),
        SELECTEDVALUE ( 'Table'[Date] ) >= DATE ( 2020, 4, 15 )
            && SELECTEDVALUE ( 'Table'[Date] ) <= DATE ( 2022, 12, 31 ), "VALID",
        SELECTEDVALUE ( 'Table'[Date] ) < DATE ( 2020, 4, 15 ), "INVALID",
        SELECTEDVALUE ( 'Table'[Date] ) > DATE ( 2022, 12, 31 ), "INVALID"
    )
RETURN
    N1

If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

 

Best Regards,

Charlotte Zhang

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

 

 

 

  • giovanni_figuei's avatar
    giovanni_figuei
    Frequent Visitor
    4 years ago

    Thank you so much helped me a lot S2