Forum Discussion

henrycqc's avatar
henrycqc
Icon for Helper II rankHelper II
4 years ago
Solved

Include only Latest 3 months of data

In power query, I want to limit the amount of data loaded into the model by only including new data within the last 3 months from a dataflow.  So far found this YouTube video “ https://youtu.be/zr52Q...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    henrycqc 

     

    Based on your initial example code:

    let
  Source = Dates,
  #"Filtered Rows" = Table.SelectRows(Source, each [dates] >= Date.AddMonths(Date.From(DateTime.LocalNow()), -3))
in
  #"Filtered Rows"

     

    Substitute [dates] here with whatever the date field in your fact table is called.

     

    Pete

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
4 years ago
let
    Today = Date.From(DateTime.LocalNow()),
    #"3m Ago" = Date.AddMonths(Today, -3),
    Dates = Table.FromList(
        List.Dates(#"3m Ago", Duration.Days(Today - #"3m Ago"), #duration(1,0,0,0)),
        Splitter.SplitByNothing(),
        {"Date"}
    )
in
    Dates