Forum Discussion
Need DAX Code
Hi suneelkethagani ,
From your example, Project ID: Project2022-01, Project2022-02... Do they represent the same Project or different ones? Also, some rows have only one status with a date, what should I do in this case?
Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?
Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Project ID: Project2022-01, Project2022-02... are the different project ids. 01, 02, 03,... represents ids.
Some projects starts with Status1, some projects starts with Status2,.... but not starts with Status5 and Status6.
https://drive.google.com/file/d/1m-2DX4knZdqESCCUT6KlNyht4TcQQDJf/view?usp=share_link
Line and Stacked Column Chart:
If the "Project 1"starts with Intake on January 1, 2022 and changed to Feasibility on March 15, 2022. Then
We need to show that project in January, February and March 2022 as count in line
and
In January 31 days, February 28 days and March 15 days need to show their averages in bars.
X-axis is Months
Thank you in advance