Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Help - Customer Categorization in selected periods

Hi, I am new to Power BI and need help on below. I have data at date and custome level with channel type. I would need to have 2 period(date) paramenters and categorize customers based on selected d...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ，

 

Would you please try to create two calculated column :

 

P = SWITCH(TRUE(),'Table'[Date]>=DATE(2020,10,1)&&'Table'[Date]<=DATE(2020,10,2),"P1",'Table'[Date] = DATE(2020,10,3),"P2")

combinations = CONCATENATEX(FILTER('Table','Table'[Customer] = EARLIER('Table'[Customer])&&'Table'[P] = EARLIER('Table'[P])),'Table'[Channel],"&")

 

 

 

Then you can create a measure for count customers in different combinations :

 

Measure = DISTINCTCOUNT('Table'[Customer])

 

 

 

For more details, please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EctwMJyl_SlIlaH8QUDWjDkBozN9GGPqSQH4JwBdWSAtGw?e=WIcDJq

 

If this post help, please consider accept it as the solution to help other member find it more quickly.

 

Best Regards,

Dedmon Dai

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-deddai1-msft ,

    Thank you so much for the help. Calculations looks perfect except that the date filter in the calculation needs to be dynamic based on selection by user. We need 2 date parameters (P1 & P2) for user to select different periods. Then based on these period selection at run time, we need to calculate combinations. Could you please help ..

     

    Thank you.