Filter data from date condition

Question

HiI have a table like this:&nbsp;DateCustomerSale1-MarC2005-AprA1006-MayB2008-JunC30015-JunA100&nbsp;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&nbsp;= FILTER (Table, &nbsp; &nbsp; &nbsp; &nbsp;AND(&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;Month(Table[Date])=6,&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;Calculate(Sum(Table[Sale]), Table[Date]&lt;Date(2022,5,31) &amp;&amp; Table[Date]&gt;Date(2022,4,1)=BLANK()))&nbsp;I cannot understand how this works. Please help me.

ashish_mathur · Answer

Hi,
You may download my PBI file from here.
Hope this helps.

duongan1602 · Answer

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 · Answer

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

isabella · Answer

Hi&nbsp;duongan1602&nbsp;We can get this &nbsp;in power query，my approach is to generate 2 table，one is&nbsp; customerInJune ，the other is customerInPrevious2Month，then do a merge to filter out the customers InPrevious2Month.&nbsp;1 .copy the original table ，then filter the date column like this:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2.copy &nbsp;the original table ，then filter the date column like this:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Then merge the two table&nbsp; ， we want to filter out the customer in table customerInPrevious2Month&nbsp;&nbsp;Now the merged &nbsp;table is &nbsp;looks like this ：&nbsp;&nbsp;&nbsp;We can remove the last column .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Best Regards,Community Support Team _IsabellaIf this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.