Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Average in costumer profiles

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 c...
Need Help
Show and Tell
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous 

I cannot fully understand your expected output.You want to get 3 for the selected customer as he always buys once every three months?Sample data and expected output will be helpful to provide an accurate solution.Please share some simfplified sample data.For further,please refer to How to Get Your Question Answered Quickly

Regards,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Here is my .pbix

https://1drv.ms/u/s!Apt7lzq2XcE5jCPtfPPkWKH3KjA5

 

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 that 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 almost the same thing, this time my patter is buy things once per two months