Filter data from date condition

Hi duongan1602 

We can get this  in power query，my approach is to generate 2 table，one is  customerInJune ，the other is customerInPrevious2Month，then do a merge to filter out the customers InPrevious2Month.

1 .copy the original table ，then filter the date column like this:

2.copy  the original table ，then filter the date column like this:

Then merge the two table  ， we want to filter out the customer in table customerInPrevious2Month

Now the merged  table is  looks like this ：

We can remove the last column .

Best Regards,

Community Support Team _Isabella

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