how to filter column on date range

[tangutoori]

 want the data for 01/04/201 to 31/03/2019 for submited date column.

please let me know how can i achevie this.

i tried 

= Table.SelectRows(#"Changed Type", each [Submission Date] > "31/03/2018" and [Submission Date] < "1/04/2019" )

how can i achieve this.

[v-shex-msft · Accepted solution]

Hi @tangutoori ,

I'd like to suggest you add type convert part in you filter condition to apply 'between' filter effect on text:

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each Date.From([Date]) > Date.From("03/31/2018") and Date.From([Date]) < Date.From("04/1/2019"))

Regards,

Xiaoxin Sheng

[Anonymous]

Hi tangutoori,

Your submission date should be Date Type and you can apply format function to use your submission date in the DAX Expressions.

Example,

Format(Submission_Date,"dd/mm/yyyy") > '31/03/2018'

Regards,

Pradeep