Timestamp Retrieval Issue for Noon Hour in Q&A Tool: AM/PM Misinterpretation?

[Jai_94]

I am attempting to retrieve data using a Q&A tool for a specific timestamp. While I can successfully fetch data for other timestamps, I encounter an issue when querying datasets within the time range of dd/mm/yyyy 12:00:00 PM to dd/mm/yyyy 12:59:59 PM. For this particular duration, the data cannot be fetched. I suspect the tool is interpreting the timestamp as AM instead of PM. Is this a common problem, and is there a workaround for it?

[Jai_94]

I am still unable to find solution, can anyone able to find soultion this issue? your help would be much appreciated

[Jai_94]

thanks for your reply ! I am getting the same error as before

and you can see the result as below screenshot

[Anonymous]

Hi @Jai_94 ,

How about omitted seconds(:ss)?

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

[Jai_94]

this works, but i need value at that particular second.

if I include seconds in the timestamp, the visual is considering it as AM. But I do not have this issue with other PM timestamp when I include with them with seconds in 24 hour format. I have only have issue with this duration. is there any other method to solve this?

[Anonymous]

Hi @Jai_94 ,

What about adding 'PM' like this? This should work.

Table with timestamp  from 1/1/2023 12:01 PM to 1/1/2023 12:59 PM

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

[Jai_94]

thanks for your reply, I can do this if I have issue for all the PM time, but I have issue only for the timestamp duration from 12:00:00 Pm to 12:59:59 PM. 

[danextian]

Hi @Jai_94 

I haven't tried this but I would a column that indicates the hour of the day. Try the following calculated columns:

Hour = 
HOUR('Table'[Column1])

Hour AM/PM = 
FORMAT ( 'Table'[Column1], "H AM/PM")