Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Jai_94
Frequent Visitor

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

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_0-1738731349409.png

 

6 REPLIES 6
Jai_94
Frequent Visitor

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

and you can see the result as below screenshot

Jai_94_1-1738808835753.png

 

 

Hi @Jai_94 ,

 

How about omitted seconds(:ss)?

vcgaomsft_0-1738810827266.png

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

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?

v-cgao-msft
Community Support
Community Support

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

vcgaomsft_0-1738805404675.png

vcgaomsft_1-1738805420825.png

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
Frequent Visitor

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
Super User
Super User

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")

danextian_0-1738741969901.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.