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")
Interkoubess's avatar
Interkoubess
Solution Sage
9 years ago

Hi Manivannan,

 

How your data are stored?

 

In power query you can use this feature as below.

I hope it helps otherwise let us know with more examples..

Thx

Manivannan's avatar
Manivannan
Helper I
9 years ago

Hi Interkoubess,

 

Thanks for the reply.

I used direct query.