loading only last 3 month data from table

[Anonymous]

Hi ,

i need data from last 3 month from a table , and it should not filter it from the current day for last three month it should consider only the month , for examble if its 23 rd of may month i need to get data from march 1 ,   i have filtered my table date column as in t his current quarter it didnt help , 

#"Filtered Rows" = Table.SelectRows(incidents_table, each Date.IsInCurrentQuarter([createdon])),

any help 

[Fowmy]

@Anonymous 

Try the following code

#"Filtered Rows" =
Table.SelectRows(incidents_table, each [createdon] >=  Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-2)) and [createdon] <= Date.From(DateTime.LocalNow())),

[Anonymous]

Hi @Fowmy 

i am getting below error 

[Fowmy]

@Anonymous 

If you do not need the time pat of the date column, you can remove the time as I showed below. Do it before filtering the dates

[Anonymous]

Hi @Fowmy 

 i didt but still its showing same error

[Fowmy · Accepted solution]

@Anonymous 

I have attached the files below my signature for you to go through and understand.