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 folks,
I have been struggling on this headcount report for a while..
I want to show the headcount variation versus previous period, which I managed to do with:
BUD_PREV_PERIOD = CALCULATE(sum(Headcount1[BUD]);DATEADD(Headcount1[PERIOD].[Date];-1;MONTH))
and then calculating the difference between Budget and BUD_prev_period.
Now I want to split that value into 2 options (measures/columns): is the headcount difference part of a certain regional plan or not (see the -1 below). I thought it would be easy with a SUMX or so but I don't get there...
Diff FOR REGION = SUMX(FILTER(Headcount1;Headcount1[REGIONAL PLAN]="YES");[BUD_diff])
Do you have any ideas? Many thanks!!
Period | Name | Region plan | Budget | |||||||
2019/1 | Person1 | Yes | 1 | Final table | 2019/1 | 2019/2 | 2019/3 | 2019/4 | 2019/5 | |
2019/2 | Person1 | Yes | 1 | Total Headcount | 2 | 1 | 1 | 0 | 0 | |
2019/3 | Person1 | Yes | 1 | Diff prev period | -1 | 0 | -1 | 0 | ||
2019/4 | Person1 | Yes | 0 | Diff (Regional plan) | -1 | |||||
2019/5 | Person1 | Yes | 0 | Diff (no plan) | 0 | -1 | 0 | 0 | 0 | |
2019/1 | Person2 | No | 1 | |||||||
2019/2 | Person2 | No | 0 | |||||||
2019/3 | Person2 | No | 0 | |||||||
2019/4 | Person2 | No | 0 | |||||||
2019/5 | Person2 | No | 0 |
Solved! Go to Solution.
Hi,
I believe this is the result you want. You may download my PBI file from here.
Hope this helps.
Hi,
I believe this is the result you want. You may download my PBI file from here.
Hope this helps.
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |