topic Convert week day hours to show total value in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Convert-week-day-hours-to-show-total-value/m-p/1469904#M27895 <P>i have data in below format :</P><DIV><TABLE><TBODY><TR><TD>Project</TD><TD>Duration</TD></TR><TR><TD>Project 1</TD><TD>&nbsp;4d</TD></TR><TR><TD>Project 2</TD><TD>&nbsp;5w 1h</TD></TR><TR><TD>Project 3</TD><TD>&nbsp;4m</TD></TR><TR><TD>Project 4</TD><TD>&nbsp;1w 5h&nbsp;</TD></TR></TBODY></TABLE><BR />I want values to be shown like total of duration , eg: 6w 4d 6h 4m&nbsp;<BR /><BR />Requirement is to show how much of time is taken to complete project out of total time<BR /><BR />Thanks for any help in advance.</DIV> Mon, 02 Nov 2020 16:33:52 GMT Anonymous 2020-11-02T16:33:52Z Convert week day hours to show total value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Convert-week-day-hours-to-show-total-value/m-p/1469904#M27895 <P>i have data in below format :</P><DIV><TABLE><TBODY><TR><TD>Project</TD><TD>Duration</TD></TR><TR><TD>Project 1</TD><TD>&nbsp;4d</TD></TR><TR><TD>Project 2</TD><TD>&nbsp;5w 1h</TD></TR><TR><TD>Project 3</TD><TD>&nbsp;4m</TD></TR><TR><TD>Project 4</TD><TD>&nbsp;1w 5h&nbsp;</TD></TR></TBODY></TABLE><BR />I want values to be shown like total of duration , eg: 6w 4d 6h 4m&nbsp;<BR /><BR />Requirement is to show how much of time is taken to complete project out of total time<BR /><BR />Thanks for any help in advance.</DIV> Mon, 02 Nov 2020 16:33:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Convert-week-day-hours-to-show-total-value/m-p/1469904#M27895 Anonymous 2020-11-02T16:33:52Z Re: Convert week day hours to show total value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Convert-week-day-hours-to-show-total-value/m-p/1470601#M27914 <P>Anonymous</LI-USER> , Are you getting duration like text or like a number ?</P> <P>Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.</P> Tue, 03 Nov 2020 02:24:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Convert-week-day-hours-to-show-total-value/m-p/1470601#M27914 amitchandak 2020-11-03T02:24:56Z