Forum Discussion

jitpbi's avatar
jitpbi
Post Patron
6 years ago
Solved

specific time from datetime field

Hi,   from the below sample data, i need to display the values on the visual only for the time period 10:00 AM to 04:00 PM:   DateTime    Predicted Value Actual Value Variation 9/8/2020...
needhelp
  • amitchandak's avatar
    amitchandak
    6 years ago

    jitpbi ,

    In power query you can use Time.Hour

    Time.Hour([Datetime])

    if you want to remove data you can now filter between 10 to 16 

     

    if Time.Hour([Datetime])  >=10 and Time.Hour([Datetime])  <=16 then 1 else 0

jitpbi's avatar
jitpbi
Post Patron
6 years ago

Hi amitchandak ,

 

Just thinking to do it in the edit query, if we can select from the datetime field for the time 10 AM to 4 PM. So the data will be loaded for 10 AM to 4 PM only. Can you please help me to do this in power query.

 

Thanks

 

 

amitchandak's avatar
amitchandak
Super User
6 years ago

jitpbi ,

In power query you can use Time.Hour

Time.Hour([Datetime])

if you want to remove data you can now filter between 10 to 16 

 

if Time.Hour([Datetime])  >=10 and Time.Hour([Datetime])  <=16 then 1 else 0

  • jitpbi's avatar
    jitpbi
    Post Patron
    5 years ago

    Hi amitchandak ,

     

    I am gettiing another challenege after republishing the report to service, where i replaced with the existing dataset, the "hour" column is not showing in the table. Also getting the data for entire time as before not for the time (>=10 &<= 16) i filtered in the power query. The same file in desktop was working fine where hour column is there in the table and data is filtered for the time >=10 &<= 16.

    Can you please suggest what would be the reason and how to resolve this.

     

    Thanks