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.
Hi BI Gurus,
Could you please help me? I am trying to present the net hires and leaves per month in a combined graph.
The data is sourced from two different sources/tables. Right now it looks like the leavers are totalling all together for 17 each month.
Could someone please recommendf do I fix this?
Solved! Go to Solution.
In your scenario, since your "number of leavers" starts from June and "number of new hires" starts from Feburary, it's better to built the relationship to a date table first. And it looks like you are using measures to calculate the count of "new hires" and "leavers". You should use ALLEXCEPT() to have your calculation group on Month level. The formula can be like:
Count of Hired Date= CALCULATE(COUNTA(Table1[HiredDate]),ALLEXCEPT(Table1,Table1[Month]))
Count of Leavers= CALCULATE(COUNTA(Table2[End Date]),ALLEXCEPT(Table2,Table2[Month]))
If you still can't fix your issue, please share your .pbix with sample data.
Regards,
In your scenario, since your "number of leavers" starts from June and "number of new hires" starts from Feburary, it's better to built the relationship to a date table first. And it looks like you are using measures to calculate the count of "new hires" and "leavers". You should use ALLEXCEPT() to have your calculation group on Month level. The formula can be like:
Count of Hired Date= CALCULATE(COUNTA(Table1[HiredDate]),ALLEXCEPT(Table1,Table1[Month]))
Count of Leavers= CALCULATE(COUNTA(Table2[End Date]),ALLEXCEPT(Table2,Table2[Month]))
If you still can't fix your issue, please share your .pbix with sample data.
Regards,
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 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |