Capacity count per week

[arp2]

I have to present a chart showing forecast headcount per week (stacked column) and I want to show two lines in the secondary y-axis (1) Current Headcount and (2) Projected Headcount. Current Headcount should show a constant number throughout all weeks whereas Projected Headcount should be a projection for each week based on the net of new joiners & terminations in each week.

Can you plz guide me?

The sample Table and desired visuals are pasted here below (charts are below the table)

Discipline	Week	Forecast	Current Headcount	Joiners	Terminations	Projected Headcount
Disc1	2/1/2024	9	10			10
Disc1	2/8/2024	9	10			10
Disc1	2/15/2024	11	10	2		12
Disc1	2/22/2024	8	10		-1	9
Disc1	2/29/2024	9	10			10
Disc1	3/7/2024	10	10	1		11
Disc1	3/14/2024	9	10			10
Disc1	3/21/2024	8	10		-1	9
Disc1	3/28/2024	9	10			10
Disc2	2/1/2024	14	15	1		16
Disc2	2/8/2024	13	15		-1	14
Disc2	2/15/2024	14	15			15
Disc2	2/22/2024	16	15	3		18
Disc2	2/29/2024	14	15			15
Disc2	3/7/2024	12	15		-2	13
Disc2	3/14/2024	14	15			15
Disc2	3/21/2024	14	15			15
Disc2	3/28/2024	14	15			15
Disc3	2/1/2024	16	17	1		18
Disc3	2/8/2024	14	17		-1	16
Disc3	2/15/2024	15	17			17
Disc3	2/22/2024	17	17	2		19
Disc3	2/29/2024	15	17			17
Disc3	3/7/2024	14	17		-1	16
Disc3	3/14/2024	15	17			17
Disc3	3/21/2024	15	17			17
Disc3	3/28/2024	15	17			17
Total	2/1/2024	40	42	2	-	44
Total	2/8/2024	36	42	-	(2)	40
Total	2/15/2024	40	42	2	-	44
Total	2/22/2024	41	42	5	(1)	46
Total	2/29/2024	38	42	-	-	42
Total	3/7/2024	36	42	1	(3)	40
Total	3/14/2024	38	42	-	-	42
Total	3/21/2024	37	42	-	(1)	41
Total	3/28/2024	38	42	-	-	42

[PijushRoy]

Hi @arp2 
I am not sure what is the issue you are facing
Are you looking for DAX calculation or your data is ready (as you shared) only you looking for visuals?
Please confirm

Look into the pbix file if only looking for visual
https://drive.google.com/file/d/1FVvtR2kpzsfHcmNn_ppJBW5pt6ROGrFL/view?usp=sharing

If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush

[arp2]

Thanks for reply. I have a table that shows count of employees in each discipline for 6-7 months period (by week). Let's say one discipline (named Disc1) has 910 employees as of week ending 2nd Feb. With turnover (new jonees as well as people leaving) next few weeks are listed with Projected Headcount. When I add the current Headcount and Projected Headcount to secondary Y-axis, the chart shows either sum of all weeks or count of all weeks based on selection in formatting. I want to show the number for each individual week in the chart.

[arp2]

@Ritaf1983 @Fowmy @Ahmedx Appreciate your help