Filter based on date

[Anonymous]

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.

[v-frfei-msft · Accepted solution]

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]

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.