Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
101
Views
Topic starter
Hi Mynda,
I am trying to replicate the following table ( attached) in Power BI. However, I am not sure if i will have to create a separate measure for each cell of the table.
Could you please look into the attached table & suggest how should i proceed on this.
Basically, I am trying to project for 3 months- the Head Count of employees ( based on Number of New joiners & Attrition ). This is possible easily on excel-however not sure the approach to follow in power BI.
Posted : 17/09/2019 1:35 am
Hi Shantanu,
Each formula you mention in the table should be a measure in your Power BI model. This is a running total type of calculation, which is a little tricky. This post should point you in the right direction.
Mynda
Posted : 17/09/2019 6:25 am
Topic starter
okay thank you Mynda.
Posted : 18/09/2019 1:18 am
