Forum Discussion

Helper I

8 years ago

Solved

Power Query relative filter for dates (months)

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

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

Anonymous

Not applicable

8 years ago

>>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