Power Query relative filter for dates (months)

[MarkShu]

Hello! 

Do you know the way to filter out the last 2 months (relative) in Power Query? 

[MarkShu · Accepted solution]

Eventually I did this with DAX: 
Clients = CALCULATE(COUNTA('Outflow'[ID]);FILTER('Outflow;'Outflow'[Date]<DATE(YEAR(today());MONTH(today())-1;1)))

[Anonymous]

Hi @MarkShu,

>>Do you know the way to filter out the last 2 months (relative) in Power Query? 

Normal filter not support this, I think you need to do some customize on fitler formula.

Add a filter on date column and use bold part to replace original date value:

#"Filtered Rows" = Table.SelectRows(#"Previous Steps", each [DATE] >= Date.AddMonths(List.Max(#"Previous Steps"[DATE]),-2))

Regards,

Xiaoxin Sheng