Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter based on date

Hi everyone.

 

I need to filter out data based on dates; my data has almost all dates from 2000 to 2019 for both start and end date columns in this form dd-mm-yyyy.

 

first column: start date: every date before 01.01.2018 should be included, any date after 01.01.2018 should be excluded. 

second column: end date: every date before 0.01.2018 should be excluded, all else included.

 

How can I do that? 

 

Thank you.

  • Hi Anonymous,

     

    We can create two calculated tables and create relationship between tables to work on it.

     

    Table = GENERATESERIES(DATE(2000,01,01),DATE(2018,01,01),1)
    Table2 = GENERATESERIES(DATE(2018,01,02),DATE(2019,12,31),1)

    Regards,

    Frank

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support

    Hi Anonymous,

     

    We can create two calculated tables and create relationship between tables to work on it.

     

    Table = GENERATESERIES(DATE(2000,01,01),DATE(2018,01,01),1)
    Table2 = GENERATESERIES(DATE(2018,01,02),DATE(2019,12,31),1)

    Regards,

    Frank

    • Anonymous's avatar
      Anonymous
      Not applicable

      Actually, after I converted the columns to dates, I could use date filters which already have after this date or before or on this date. 

       

       

      Thanks for your help as well. Good to know that you can apply different solutions and get the results you need.

       

      Thank you again.