Forum Discussion

Shelley's avatar
Shelley
Post Prodigy
8 years ago
Solved

Limit dateset by timeframe in Query Editor

Hi All, Man, I just don't get the M Language. Looking for help please. I want to limit our dataset by the create date. I want everything five years backwards from today. The built-in selections don'...
  • ImkeF's avatar
    ImkeF
    8 years ago

    This error message usually means that you're missing a closing parenthesis :)

     

    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Order_Submit_Date] > Date.AddYears(Date.From(DateTime.LocalNow()), -5) )