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.

     

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

giovanni_figuei 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.