Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

loading only last 3 month data from table

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 

Data Protection
General Comment
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests

5 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Fowmy 

      i am getting below error 

       

       

      • Fowmy's avatar
        Fowmy
        Super User
        5 years ago

        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