Forum Discussion

Jai_94's avatar
Jai_94
Frequent Visitor
1 year ago

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...
Need Help
Jai_94's avatar
Jai_94
Frequent Visitor
1 year ago

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

and you can see the result as below screenshot

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      Jai_94
      Frequent Visitor
      1 year ago

      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?