Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello guys,
I m facing problem while applying formula
Problem is : i have actual sales and expected sales of different salesperson. Expected sale is in the form of range (Ex- 20-20K, 20-30K etc). I have to see how many sales person are able to get his expected sales. and if his sales is below than expected sales then i should get 0 corresponding to his exopected sales range. that is 0 person achive this target
EX- Actual sales 10K, Expected sales is 5K-15K, i have 100 sales person. now how can i write a formula so that i can see how many of salesperson out of 100 is capable of meeting his target 5K-15K .
Please guide!
Hi @Anonymous,
Most of edit functions(include create measure and columns) has been disabled on service side. Please create report on power bi desktop then publish to power bi service.
Sample steps:
1. Create calculated column to check current sales range as category.
2. Use above category column and person id with count of person id to create visual.
If you are confused on coding formula, please share some sample data for test.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.