IF Statement with filter measure

[gauravnarchal]

Dear All

I need your help on this measure.. 

If a month difference is >12 it should return the result as "Existing Client" else all other clients should be ignored and should not show in the results.

Can i add a filter in the below IF statement measure?

GN Customer Status =

IF([GN Months Difference]>12,"Existing Client")

[amitchandak]

@gauravnarchal , You can get last purchase date for the customer from this blog

https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak

if(datediff([last sales/purcahse],today(),month)<12, "Existing Client")

[AllisonKennedy]

You could try the FILTER function. How are you using this measure? You can always filter the visual to remove 'blank' or 'null' values that will currently be returned by your IF statement.