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 ...
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. 

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.