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,
Who can help me on this urgent subject please,
I have a table that contains the following data on power BI
my request is :
Calculate each Employee Group’s Headcount change per year as a percentage comparing to prev year.
how I can do this calculation on dax for final objective to make this visual?
Solved! Go to Solution.
I share with you an example for my data
Calendar year | Headcount | Employee Group | Directorate |
2013 | 10 | Temporary | SGE |
2013 | 13 | Official | EXD |
2017 | 12 | Official | CTP |
2017 | 10 | Official | DAF |
2017 | 13 | Temporary | EDU |
2014 | 11 | Official | EDU |
2014 | 10 | Temporary | EDU |
2015 | 10 | Official | NEA |
2016 | 13 | Official | EXD |
2016 | 15 | Temporary | EDU |
2017 | 10 | Official | EDU |
2017 | 11 | Official | ELS |
2017 | 10 | Official | GOV |
2018 | 12 | Temporary | GOV |
2018 | 10 | Official | NEA |
2019 | 10 | Temporary | CFE |
2019 | 12 | Official | EXD |
2020 | 10 | Temporary | GOV |
2020 | 11 | Official | GOV |
2020 | 10 | Official | GOV |
2021 | 11 | Official | EXD |
2021 | 15 | Official | CTP |
2021 | 11 | Official | STI |
2022 | 10 | Official | EXD |
2022 | 11 | Official | EXD |
2022 | 11 | Associated staff | CTP |
2022 | 15 | Official | CTP |
2022 | 14 | Official | CTP |
2022 | 13 | Temporary | EDU |
@Nihed can you paste a table with the expected results? I can't understand how you obtain 12,5% for example in the first chart for 2013.
BBF
@Nihed Access is denied. Try this measures:
It doesn’t work I have the Media measurement equal 0
how I can do it I don’t know how,if you can do it yourself I’d be grateful
I couldn’t have sent you this I’ve been sitting for a while and it’s not working
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |