Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |