Forum Discussion
Helper IDAX for projects completed per month
I have 123 Projects out of which 13 are completed and 110 are still active. each project takes 60 hours to complete from the date it got started. We take 6 months to complete each project. How do I show the data in the form of a stacked column chart. Is there any DAX to show the data from Jan to Dec of 2024 per month how many projects are we currently working with 60 hours to complete each project in next 6 months. (FYI - This is a sample data)
https://docs.google.com/spreadsheets/d/1XPCvuTOzT0OjROe3HP_2uZpG7JFjmF7IIqdWLoml7pY/edit?usp=sharing
Thanks!
2 Replies
- amitchandak
Super User
chitti5 , I think, this is same as HR Active employee, the file have tenure calculation
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
chitti5amitchandak Hello Sir, Thank you for the reply. I watched the video and applied the same measures to get the results. I was able to achieve 50% output. But, I'm not getting the exact output I want. I wanted to show active projects from Jan to Dec months until it is completed. But I'm getting the same results for other status as well like "completed", "on hold", and "Killed". Even they are moving to the next month and these projects are shown in the next months.
But I want to show completed projects count only for that month and for other status as well except for active status I want to show the rest status in those months which it occured.
Please find the screenshot below for better understanding.
For example I have only 2 projects completed in january 2024 but all the 456 got continued from 2023 Dec data. Please share a DAX measure to get only the counts per month that occured for Completed, Killed and On hold status.
Thank you!
