Forum Discussion
gauravnarchal
Post Prodigy
Post ProdigyIF Statement with filter measure
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")
2 Replies
- AllisonKennedy
Community Champion
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. - amitchandak
Super User
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")
