Forum Discussion
Set Target for Salesman
Need Measure of New Column formula to achieve Target Vs Actuals
| Collection | Salesman | Collection Target in % | Collected Actual |
| 1000 | 1 | 50 | 200 |
| 2000 | 2 | 65 | 100 |
| 3000 | 3 | 25 | 150 |
| 4000 | 4 | 75 | 450 |
| 500 | 5 | 2 | 2 |
I need to set Target for each salesman & show the actuals date-wise
Collection & Salesman are my datasets
5 Replies
Please follow the recommendations in this thread to help us help you:
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
SAD
I need a Measure or Column to store my random target value given to Salesman
& collected acutals aginst the Target achieved
Hoping this is clear
Collection as on 04-09-21 Balance Salesman Collection Target in % (measure or column) Collected Actual (output) 04-09-2021 1000 1 50% 04-09-2021 2000 2 65% 04-09-2021 3000 3 25% 04-09-2021 4000 4 75% 04-09-2021 500 5 2% Eg: Salesman 1 must collect 50% of his balance amount that is 1000
what he acheived must be stored in the collected actuals output
Sorry, it's not at all clear.
Please follow the recommendations in the thread I posted. You need to provide sample data, model structure, expected output and if possible a sample PBIX file.
Otherwise it a shot in the absolute dark.For example, what do you mean by "random target value"? Is this "random target value" by date & salesman? by salesman? Do you want it to be calculated once? Dynamically (not sure it's possible...)?
Target percentage based on Balance
once
Dynamically
My Target changes fortnight
Target set on 04-09-2021 & next random target will be set on 18-09-2021
