topic show work status in DAX Commands and Tips

topic show work status in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/show-work-status/m-p/3094988#M156931 <P>Would like to show follwing data to look like what is draw. Some of the End date are missing in the data i have. Do i use Gantt chart for this? </P><TABLE><TBODY><TR><TD>start date </TD><TD>End date</TD><TD>No of work done</TD><TD>No of work ongoing</TD><TD>work type</TD></TR><TR><TD>23/1/2023</TD><TD>21/2/2023</TD><TD>1</TD><TD> </TD><TD>m</TD></TR><TR><TD>10/2/2023</TD><TD>2/3/2023</TD><TD>1</TD><TD> </TD><TD>c</TD></TR><TR><TD>12/3/2023</TD><TD>23/4/2023</TD><TD>1</TD><TD> </TD><TD>c</TD></TR><TR><TD>22/4/2023</TD><TD>21/5/2023</TD><TD>1</TD><TD> </TD><TD>m</TD></TR><TR><TD>2/5/2023</TD><TD>18/6/2023</TD><TD>1</TD><TD> </TD><TD>m</TD></TR><TR><TD>29/6/2023</TD><TD>Nil</TD><TD> </TD><TD>1</TD><TD>c</TD></TR><TR><TD>…</TD><TD>…</TD><TD>…</TD><TD>…</TD><TD>…</TD></TR></TBODY></TABLE><P><img /></P><P> </P> Fri, 24 Feb 2023 00:45:11 GMT Yqy 2023-02-24T00:45:11Z show work status https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/show-work-status/m-p/3094988#M156931 <P>Would like to show follwing data to look like what is draw. Some of the End date are missing in the data i have. Do i use Gantt chart for this? </P><TABLE><TBODY><TR><TD>start date </TD><TD>End date</TD><TD>No of work done</TD><TD>No of work ongoing</TD><TD>work type</TD></TR><TR><TD>23/1/2023</TD><TD>21/2/2023</TD><TD>1</TD><TD> </TD><TD>m</TD></TR><TR><TD>10/2/2023</TD><TD>2/3/2023</TD><TD>1</TD><TD> </TD><TD>c</TD></TR><TR><TD>12/3/2023</TD><TD>23/4/2023</TD><TD>1</TD><TD> </TD><TD>c</TD></TR><TR><TD>22/4/2023</TD><TD>21/5/2023</TD><TD>1</TD><TD> </TD><TD>m</TD></TR><TR><TD>2/5/2023</TD><TD>18/6/2023</TD><TD>1</TD><TD> </TD><TD>m</TD></TR><TR><TD>29/6/2023</TD><TD>Nil</TD><TD> </TD><TD>1</TD><TD>c</TD></TR><TR><TD>…</TD><TD>…</TD><TD>…</TD><TD>…</TD><TD>…</TD></TR></TBODY></TABLE><P><img /></P><P> </P> Fri, 24 Feb 2023 00:45:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/show-work-status/m-p/3094988#M156931 Yqy 2023-02-24T00:45:11Z