Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi Community,
It is possible to expand my existing matrix as follows.
current matrix
I would like to have two lines instead of one line for each project.
One line should contain the scheduled dates and the other the achieved dates.
Datetable
Table: Milestones and dates
Solved! Go to Solution.
Hello @Lachsforelle12 ,
To achieve this it is necessary to refer to my question in your other post which is how to identify the planned tasks versus achieved, if it is column with a specific term saynd planned /achieved or a date that says date achived you just have to use that column to make the split between the two dates.
If you can share how to make that distinction in your model the configuration of the above measure that I prepared for you should be quite straightforward.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHello @Lachsforelle12 ,
To achieve this it is necessary to refer to my question in your other post which is how to identify the planned tasks versus achieved, if it is column with a specific term saynd planned /achieved or a date that says date achived you just have to use that column to make the split between the two dates.
If you can share how to make that distinction in your model the configuration of the above measure that I prepared for you should be quite straightforward.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCheck out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!