Forum Discussion
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?
- Anonymous3 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 _resultOutput
Best Regards,
Gao
Community Support TeamIf 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
2 Replies
- AnonymousNot applicable
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 _resultOutput
Best Regards,
Gao
Community Support TeamIf 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
- AnonymousNot applicable
Much appreciated, exactly what I need. Thank you!!