Need to set up a message that changes

[darrennhg]

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?

[v-cgao-msft · Accepted solution]

Hi @darrennhg ,

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

[darrennhg]

Much appreciated, exactly what I need. Thank you!!