Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Benjosh
Helper I
Helper I

Set Target for Salesman

Need Measure of New Column formula to achieve Target Vs Actuals

CollectionSalesmanCollection Target in %Collected Actual
1000150200
2000265100
3000325150
4000475450
500522

I need to set Target for each salesman & show the actuals date-wise

Collection & Salesman are my datasets

5 REPLIES 5
PaulDBrown
Community Champion
Community Champion

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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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

Benjosh
Helper I
Helper I

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-21BalanceSalesmanCollection Target in % (measure or column)Collected Actual (output)
04-09-20211000150% 
04-09-20212000265% 
04-09-20213000325% 
04-09-20214000475% 
04-09-202150052% 

 

Eg: Salesman 1 must collect 50% of his balance amount that is 1000

what he acheived must be stored in the collected actuals output

Benjosh
Helper I
Helper I

SAD

PaulDBrown
Community Champion
Community Champion

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 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.