PowerQuery: Filter: Keep all data till two months ago

[iiomarioii]

Hi guys,

I would like to filter my query in PowerQuery with my Date column. I would like to keep all data till 2 months ago (so from todays view it would be till 24/09/2020)

What's the equivalent in DAX?

Any ideas? 

Thank you very much! 🙂

iiomarioii

[v-yangliu-msft · Accepted solution]

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.

[ryan_mayu]

@iiomarioii 

maybe you can create a new table

Table 2= FILTER(Table, [date]>=edate(today(),-2))