Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Timestamp Column

How can I pull out data from below column that will show requests before thursday @ 3:30pm and after ending on Sunday. Hope I explained that right?       Timestamp 2018-10-10 12:40:27 2...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous

     

    You could create a new table:

     

    NewTable =
FILTER (
    Table1;
    Table1[Timestamp] >= DATE ( Year1; Month1; Day1 ) + TIME ( Hour1; Month1; Second1 )
    && 
        Table1[Timestamp] <= DATE ( Year2; Month2; Day2 ) + TIME ( Hour2; Month2; Second2 )
)

    where Table1 is your current table and Year1, Month1, etc  and Year2, Month2, etc. are the initial and final date/time within which you want to keep dates (your Thursday and Sunday in your example), 

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

Anonymous

 

I create a new column to find the values in the scope or out of scope. I am not sure if this is what you want.

 

 

 

Column = 
VAR day = WEEKDAY(Sheet2[Timestamp],1)
VAR time=TIMEVALUE(Sheet2[Timestamp])
return if((day=5&&time>=TIME(15,00,00))||day=6||day=7,"No","Yes")

Thanks and BR

Ryan

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    OK I create a custom column, I get an error.

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      7 years ago

      Anonymous

       

      Not in the edit queries. That is for M. You need to create a column in the modeling. That is for DAX.

       

      • AlB's avatar
        AlB
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Anonymous

        You can also do it in the query editor, just filtering with the Date/Time Filters --> Between...

        Choose the date and simply write the time next to the date: