Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to filter by date and time?

I have made the new column called BDFT which is great! However it calculates everything all the days and times. I want to make two columns of BDFT..using the formula BDFT = Qty * Volume, I want one t...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Anonymous ,

     

    I create two columns so that it might be easier to see. HOUR() returns 1-24, so notice that there is an OR which is || .

     

     

    Let me know if you have any questions.

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

    Day = If(Hour('Table (3)'[Column1])>4 && Hour('Table (3)'[Column1])<14,"Day")

Night = if(HOUR('Table (3)'[Column1]) >= 14 && HOUR('Table (3)'[Column1]) <24 || HOUR('Table (3)'[Column1]) <2 ,"Night")

     

     

     

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi Anonymous ,

 

I create two columns so that it might be easier to see. HOUR() returns 1-24, so notice that there is an OR which is || .

 

 

Let me know if you have any questions.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Day = If(Hour('Table (3)'[Column1])>4 && Hour('Table (3)'[Column1])<14,"Day")

Night = if(HOUR('Table (3)'[Column1]) >= 14 && HOUR('Table (3)'[Column1]) <24 || HOUR('Table (3)'[Column1]) <2 ,"Night")