PowerQuery: Filter: Keep all data till two months ago

Hi  iiomarioii ,

You can't write DAX in power query, you can only go to some DAX in desktop

According to your description, I created some data to show:

Here are the steps you can follow：

1. Create measure.

Measure =
CALCULATE(SUM('Table (2)'[amount]),FILTER('Table (2)','Table (2)'[Date]<=DATE(YEAR(TODAY()),MONTH(TODAY())-2,DAY(TODAY()))))

2. Result.

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

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