Get data for the last X days including today

Unfortunately Date.IsInPreviousNDays does not include the date of today. The image on this page illustrates this: https://powerquery.how/date-isinpreviousndays/

You could use: 

Table.SelectRows(
  Source, 
  each [datetime] >= Date.AddDays( DateTime.LocalNow(), -7 ) 
    and [datetime] <= DateTime.LocalNow() 
)

Notice that even if you subtract days from a datetime value, the output is still a datetime value (https://powerquery.how/date-adddays/). 

--------------------------------------------------

@ me in replies or I'll lose your thread

Master Power Query M? -> https://powerquery.how

Read in-depth articles? -> BI Gorilla

Youtube Channel: BI Gorilla

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.