Forum Discussion

imontoya14's avatar
imontoya14
Frequent Visitor
5 years ago
Solved

Filtering time for each day

Hi there, I'm not sure how easy this is but I've been stumped on this for a while. How can I pull the time to only show 6AM to 7PM everyday? instead of it showing 3AM and 9AM. I would like to remove all the data overnight and only have the report show 6AM to 7PM each day. 

 

 

 

Any help is appreciated. Thank you. 

Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    create a calculated column  HOUR(timestamp)  and then use that column to filter your visual.

  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi imontoya14

     

    You can also try to create measure as:

    Measure = 
CALCULATE(
    MAX(Table[Megawatts],
    FILTER(
        Table,
        HOUR([Time])>6 && HOUR([Time])<19 && HOUR([Time])<>7
)
)

     

    Best Regards,

    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly. 

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    create a calculated column  HOUR(timestamp)  and then use that column to filter your visual.

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi imontoya14

     

    You can also try to create measure as:

    Measure = 
CALCULATE(
    MAX(Table[Megawatts],
    FILTER(
        Table,
        HOUR([Time])>6 && HOUR([Time])<19 && HOUR([Time])<>7
)
)

     

    Best Regards,

    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.