Forum Discussion
Calculate and creating user profile
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
1 Reply
HI Anonymous ,
Power bi not support analytics text value, I think you need to add calculation columns to grouping these customer based on their frequency more clarify.
After these, you can write measures to check these records based on frequency group and return correspond notice.
Regards,
Xiaoxin Sheng