How to query day old data ?

Yes, this is possible, and you can even have this folded to your server to do all of the work if it is a supported relational database, like SQL Server.

If you have a time stamp in your system, you just need to create a variable in Power Query. For example, our system uses YYYYMMDD for dates (integers) vs a true date field. I needed to create a query that only pulled the most recent year. I called this "varOneYearAgo" as the query, and it returns an integer.

let
    Source = DateTime.LocalNow(),
    #"Current Date" = DateTime.Date(Source),
    #"One Year Ago" = Date.AddYears(#"Current Date",-1),
    #"Final Date" = Date.Year(#"One Year Ago") * 10000 + Date.Month(#"One Year Ago") * 100 + Date.Day(#"One Year Ago")
in
    #"Final Date"

This returns 20181025 today. Just change your function to use Date.AddDays to go back one day, then your #"Final Date" statement would need to be whatever it took to get a date in the same format as your system.

Then as an example, this is the M code to pull a table and only return order numbers less than 1 year old:

let
    Source = Sql.Database("Server", "Database"),
    dbo_TableName= Source{[Schema="dbo",Item="dbo_TableName"]}[Database],
    #"Removed Other Columns" = Table.SelectColumns(dbo_TableName,{"ord_no", "ord_dt"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each ([ord_dt] >= varOneYearAgo))
in
    #"Filtered Rows"

The SQL this generates and sends to the server is:

select [_].[ord_no],
    [_].[ord_dt]
from 
(
    select [ord_no],
        [ord_dt]
    from [dbo].[TableName] as [$Table]
) as [_]
where [_].[ord_dt] >= 20181025

Notice it relaced the variable with the integer that varOneYearAgo returned.