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])),
Solved! Go to Solution.
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())),
Check out new user group experience and if you are a leader please create your group!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates