Forum Discussion
Matrix to display total days spent on the task - Conditional formatting based on late or on-time.
Super UserHi Chintan
It is a calassic cantt chart.
Please refer to the linked tutorials
https://www.youtube.com/watch?v=UVDR3HFncKU
https://www.youtube.com/watch?v=8pbFvBMT9L8
https://www.youtube.com/watch?v=cdUg8LfarCg
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thank Ritaf for your time and response.
The videos are very helpful however I am not looking for Gantt Chart, it's kinda similar but what I want to achieve is still different to Gantt Chart and videos are all about Gantt Chart.
I want to write a DAX that count total days from the startdate and diaplay total days from Day 1 in the Matrix as shown in the screenshot. For example; first task in the screenshot took 21 days since startdate.
Many thanks.