Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Time Filter - 19:00-07:00

I have a column with 60,000+ rows, the format of which is:   07:00 08:23 22:01   Any idea how I could apply a quick filter for times between 19:00 - 07:00?    
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous,

    Based on my test, you could refer to below formula:

    Column = IF([Time]>=TIME(19,0,0)||[Time]<=TIME(7,0,0),1,0)

    Result:

     

    Regards,

    Daniel He

     

Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
7 years ago

Hi Anonymous,

You can filter the data inside Power Query by filtering on the time column