Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
hi guys,
i have data like the below table
customer | date | sale |
x | 07/18/2022 | 23,000 $ |
y | 07/15/2022 | 53,000 $ |
z | 07/10/2022 | 36,000 $ |
x | 02/22/2022 | 10,000 $ |
z | 05/17/2022 | 23,000 $ |
i have 2 rule that i want to implement it:
if total sale of a customer is less than 55,000 $ then label it as A
else label it as B
and finally i want to have a chart that shows me how many percent of my customers is labeled as A and B
how can i achieve this?
thanks.
Solved! Go to Solution.
@alisoroush7, yes it's possible.
Please don't forget to accept the solution and will appreciate your Kudos on my solutions 🙂
Here is a link to download the file with the updated solution:
categorize customer 2022-07-20.pbix
@alisoroush7
Here is a link to download the file with the solution:
categorize customer 2022-07-20.pbix
thank you for your respons. with this code my request has been satisfied 80%.
i have another issue. the issue is that i have a date filter. for example month. when i filter my dashboard in a specific month, i want that code to consider only the chosen month data and label the customer based on a chosen month. for example it is possible that one customer is labeled A in July but it is labeled B in March.
@alisoroush7, yes it's possible.
Please don't forget to accept the solution and will appreciate your Kudos on my solutions 🙂
Here is a link to download the file with the updated solution:
categorize customer 2022-07-20.pbix
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
34 | |
14 | |
12 | |
12 | |
11 |