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,
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
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |