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 ...
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