Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Can you guys please help me in deducing a solution for this ?-
KPI: Attrition in % and Number for the selected period. (Refer to 'Calculations' Part for explaination)
Calculation-
Data ->
I just need an approach to do it. Many thanks
Solved! Go to Solution.
@subho220 - If I understand correctly:
Measure Total Leavers =
VAR __Start = <start date>
VAR __End = <end date>
RETURN
COUNTROWS(FILTER('Table',[TerminationDate] >= __Start && [TerminationDate]<=__End))
I have a bunch of recipes for this sort of thing in DAX Cookbook in Chapter 7: https://github.com/gdeckler/DAXCookbook
@subho220 , refer my HR blog, see if this can help
Thanks a lot. It is really helpful.
@subho220 - If I understand correctly:
Measure Total Leavers =
VAR __Start = <start date>
VAR __End = <end date>
RETURN
COUNTROWS(FILTER('Table',[TerminationDate] >= __Start && [TerminationDate]<=__End))
I have a bunch of recipes for this sort of thing in DAX Cookbook in Chapter 7: https://github.com/gdeckler/DAXCookbook
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |