Forum Discussion

iiomarioii's avatar
iiomarioii
Helper II
5 years ago
Solved

PowerQuery: Filter: Keep all data till two months ago

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 equiva...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years 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.

Anonymous's avatar
Anonymous
Not applicable
5 years 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.