Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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?
thanks for your reply ! I am getting the same error as before
and you can see the result as below screenshot
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
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?
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
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.
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")
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
72 | |
62 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
62 | |
59 | |
56 |