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 everyone.
I have the following data table.
When a salesrep completes a sale my firm count it as 1 dealpoint
But when 2 salesrep are involved each of them splits 1dealpoint/2 so 0.5 each for example(Row 6 "KEVIN & JOHN")
And if 3 salesrep are involved each gets 1/3=0.33 (Row 9 "BILL & JOHN & ROBERT")
I want powerbi to calculate the dealpoints for each salesrep so i can include them in my dashboard.
The commisison varies between each rep but it is not relatable to the dealpoints.
Thanks!
Solved! Go to Solution.
HI @commited2020,
You can use the following calculated column formula to get the current sales rep count to calculate the correspond HC(headcount) weight.
Salesrep rate =
VAR _length =
PATHLENGTH ( SUBSTITUTE ( Table[Sales Rep], "&", "|" ) )
RETURN
1 / _length
Regards,
Xiaoxin Sheng
HI @commited2020,
You can use the following calculated column formula to get the current sales rep count to calculate the correspond HC(headcount) weight.
Salesrep rate =
VAR _length =
PATHLENGTH ( SUBSTITUTE ( Table[Sales Rep], "&", "|" ) )
RETURN
1 / _length
Regards,
Xiaoxin Sheng
Thank u very much it worked!
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.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |