Filter data from date condition

[duongan1602]

Hi

I have a table like this: 

Date	Customer	Sale
1-Mar	C	200
5-Apr	A	100
6-May	B	200
8-Jun	C	300
15-Jun	A	100

I want to filter customer that bought in June but did not buy 2 month ago (May bought in March)

I've try this function but it not working

= FILTER (Table,

       AND( 

       Month(Table[Date])=6, 

       Calculate(Sum(Table[Sale]), Table[Date]<Date(2022,5,31) && Table[Date]>Date(2022,4,1)=BLANK())

)

I cannot understand how this works. Please help me.

[isabella]

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.

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[duongan1602]

Hi, thank you for reply. I have read your PBI but not exactly what I need. 

I want to filter my table (export new table) to continue calculating data, so i need help to find a function to so my solution.

[Ashish_Mathur]

I do not understand what you want.  I have generated my result by writing a measure and have then used that meaure to filter the visual.