Forum Discussion

Manivannan's avatar
Manivannan
Helper I
9 years ago
Solved

Time Zones

Hi,   I have created a measure to display "Time", i need AM/PM also to be displayed along with it. How to achieve that?       Regards, Manivannan M  
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Actually I have litlle knowledge of DAX, and even less of Direct Query, but if your formula works, then I guess this will work as well:

     

    CurrentTime = "Time : " & IF(HOUR(NOW()) < 1,12,if(HOUR(NOW())>12,HOUR(NOW())-12,HOUR(NOW()))) & ":" & MINUTE(NOW()) & ":" & SECOND(NOW()) & IF(HOUR(NOW())<12," AM"," PM")
Manivannan's avatar
Manivannan
Helper I
9 years ago

Hi Marcel,

 

Thanks for the help. It worked for me.

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

Manivannan,

 

Since your problem has been resolved, please help accept solution. Your contribution is highly appreciated.