I need a Measure, or anything else that show me the fallowing situation: Every costumer have a profile, that means they buy things in some months with the same interval ( for example, i can have on costumer that buy our products on january,april,july,october. That means he always buys once every three months). I need to calculate this profile for my list of clients, and show in a chart/table the costumer who didnt buy anything in the profile they have.
EXAMPLE:
When i set "A A R DA SILVA EPP" in the slicer value i can see he have the profile of buy things once per month( April to August, he bought every month) but i can see in September he didnt buy, i had to make a alert(could be anything, conditional formatting) that shows me i have to pay attention on him cause he run away from his pattern(buy things once per month)
When i set "A AVALLONE SANTOS ACESSORIOS-ME" i need to do the same thing, but i can see, this user buys once per two months, He didnt buy on January 2019 so i have to put this alert
PBIX link: https://1drv.ms/u/s!Apt7lzq2XcE5jCQ-7E-fJUay-CKK
