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
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

You can create a new calculated column to determine parameter for each customer by date:

 

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

 

Then you can create  a matrix for your expected output:

 

 

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

 

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

 

Best Regards,

Dedmon Dai