Time Zones

[Manivannan]

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

[Interkoubess]

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]

Hi Interkoubess,

Thanks for the reply.

I used direct query.

[MarcelBeug]

Either =NOW() and format as hh:mm:ss tt

or = FORMAT(NOW(), "hh:mm:ss AM/PM")

By the way: this is more about time format than time zones, as the subject suggests.

[Manivannan]

Hi MarcelBeug,

Thanks for the reply. I used direct query for this, i guess FORMAT() will not work for direct query.

Is their any other way to achieve that?

[v-chuncz-msft]

@Manivannan,

By the way, to ensure that queries sent to the underlying data source have acceptable performance, limitations are imposed on measures by default. Advanced users can choose to bypass this limitation by selecting File > Options and settings > Options > DirectQuery, then selecting the option "Allow unrestricted measures in DirectQuery mode".

[MarcelBeug · Accepted solution]

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]

Hi Marcel,

Thanks for the help. It worked for me.

[v-chuncz-msft]

@Manivannan,

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