Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need to set up a message that changes

Hey guys I need to set up a message on Power BI using DAX that changes after 1pm everyday. Can someone help me with that?
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Please create a new measure:

    Measure = 
    VAR _now = NOW()
    VAR _time = TIME(13,0,0)
    VAR _result = IF(HOUR(_now)>=HOUR(_time),"Messages after 1:00 p.m.","Messages before 1:00 p.m.")
    RETURN
    _result

    Output

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum