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.
Dear Community,
Hope my message finds you well and healthy!
I need to calculate the top 1 manager in a quarterly team race and to compare it with the top 1 manager from the previous quarter.
As of now I was able to find the name with the following code (HRM stands for Highest Ranking Manager):
Coefficient is nothing but Opps divided by Empl Number.
Furthermore I have calculated HRM LQ (highest ranking manager last quarter) with the following code:
HRM LQ =
While the only one I need to be divided is Coefficient = 23.
Can anyone help me with that?
Thank you in advance,
Atanas
Solved! Go to Solution.
You need to add a check to make sure that [HRM] is not blank,
New Coeff =
VAR currentHRM = [HRM]
RETURN
IF (
NOT ( ISBLANK ( currentHRM ) )
&& currentHRM = [HRM LQ],
DIVIDE ( [Coefficient], 2, BLANK () ),
[Coefficient]
)
You need to add a check to make sure that [HRM] is not blank,
New Coeff =
VAR currentHRM = [HRM]
RETURN
IF (
NOT ( ISBLANK ( currentHRM ) )
&& currentHRM = [HRM LQ],
DIVIDE ( [Coefficient], 2, BLANK () ),
[Coefficient]
)
@johnt75 - Thank you so much for your help, it works like a charm! You made my day! Wish you all the best.
All due respect,
Atanas
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |