topic Re: Transformed table with new rows in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Transformed-table-with-new-rows/m-p/1510816#M29342 <P>Anonymous</LI-USER> , Not very clear. But refer if my blog can help</P> <P>#POWERBI: How to divide/distribute values between start date or end date or count days across months/days: <A href="https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785</A></P> Mon, 23 Nov 2020 11:01:53 GMT amitchandak 2020-11-23T11:01:53Z Transformed table with new rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Transformed-table-with-new-rows/m-p/1510727#M29340 <P>Good day everyone.<BR />I need to make transformed table using data from next table:&nbsp;</P><TABLE border="1"><TBODY><TR><TD>IDLE_ID</TD><TD>START_DT</TD><TD>START_TIME</TD><TD>END_DT</TD><TD>END_TIME</TD><TD>IDLE_TYPE</TD></TR><TR><TD>122851</TD><TD>09.09.2019</TD><TD>05:57:00</TD><TD>01.10.2019</TD><TD>09:00:00</TD><TD>Planned</TD></TR><TR><TD>123111</TD><TD>01.10.2019</TD><TD>09:30:00</TD><TD>02.10.2019</TD><TD>17:00:00</TD><TD>Planned</TD></TR></TBODY></TABLE><P><BR />I need to make visualization like this (abridged example):</P><TABLE border="1"><TBODY><TR><TD>IDLE_ID</TD><TD>START_DT</TD><TD>START_TIME</TD><TD>END_DT</TD><TD>END_TIME</TD><TD>IDLE_TYPE</TD></TR><TR><TD>122851</TD><TD>09.09.2019</TD><TD>05:57:00</TD><TD>09.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>10.09.2019</TD><TD>00:00:00</TD><TD>10.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>11.09.2019</TD><TD>00:00:00</TD><TD>11.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>12.09.2019</TD><TD>00:00:00</TD><TD>12.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>13.09.2019</TD><TD>00:00:00</TD><TD>13.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>14.09.2019</TD><TD>00:00:00</TD><TD>14.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>15.09.2019</TD><TD>00:00:00</TD><TD>15.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>25.09.2019</TD><TD>00:00:00</TD><TD>25.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>26.09.2019</TD><TD>00:00:00</TD><TD>26.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>27.09.2019</TD><TD>00:00:00</TD><TD>27.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>28.09.2019</TD><TD>00:00:00</TD><TD>28.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>29.09.2019</TD><TD>00:00:00</TD><TD>29.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>30.09.2019</TD><TD>00:00:00</TD><TD>30.09.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>122851</TD><TD>01.10.2019</TD><TD>00:00:00</TD><TD>01.10.2019</TD><TD>09:00:00</TD><TD>Planned</TD></TR><TR><TD>123111</TD><TD>01.10.2019</TD><TD>09:30:00</TD><TD>01.10.2019</TD><TD>24:00:00</TD><TD>Planned</TD></TR><TR><TD>123111</TD><TD>02.10.2019</TD><TD>00:00:00</TD><TD>02.10.2019</TD><TD>17:00:00</TD><TD>Planned</TD></TR></TBODY></TABLE><P><BR />I know, it looks really strange, but i need this visualization for easy count of idle for each day. Also first table was formed in DirectQuery, and i need not to change&nbsp;initial table.<BR />Any suggestions come useful.<BR />Best regards<BR />Alexandr</P> Mon, 23 Nov 2020 10:33:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Transformed-table-with-new-rows/m-p/1510727#M29340 Anonymous 2020-11-23T10:33:25Z Re: Transformed table with new rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Transformed-table-with-new-rows/m-p/1510816#M29342 <P>Anonymous</LI-USER> , Not very clear. But refer if my blog can help</P> <P>#POWERBI: How to divide/distribute values between start date or end date or count days across months/days: <A href="https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785</A></P> Mon, 23 Nov 2020 11:01:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Transformed-table-with-new-rows/m-p/1510816#M29342 amitchandak 2020-11-23T11:01:53Z Re: Transformed table with new rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Transformed-table-with-new-rows/m-p/1518615#M29572 <P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>This is link to .pbix example of data from my existing table</P><P><A title="This is link to .pbix example of table" href="https://arcelormittal-my.sharepoint.com/:u:/g/personal/alexandrvpat_arcelormittal_com1/ETL8_ueG8zlMsC_stIcgCU8Bx2wcy9LJ5zXgu_h2rJzfAQ?e=wFt4Qo" target="_self">https://arcelormittal-my.sharepoint.com/:u:/g/personal/alexandrvpat_arcelormittal_com1/ETL8_ueG8zlMsC_stIcgCU8Bx2wcy9LJ5zXgu_h2rJzfAQ?e=wFt4Qo</A>&nbsp;</P><P>As you can see in .pbix file, i understood how to use your method, but main problem is that i can't use measure day for count of idle time.<BR />Please check correctness of my actions in this file.<BR />Best regards, Alexandr</P> Thu, 26 Nov 2020 10:55:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Transformed-table-with-new-rows/m-p/1518615#M29572 Anonymous 2020-11-26T10:55:04Z