https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-calculated-table-with-multiple-calculated-column-from/m-p/1259841#M20937 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="249391" data-lia-user-login="armeizal" class="lia-mention lia-mention-user">armeizal</a> , Create a common date table and use countrows from each table .</P> <P>&nbsp;</P> <P>To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer : <BR /><A href="https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions" target="_blank">https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions</A> <BR /><A href="https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi" target="_blank">https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi</A><BR /><A href="https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/" target="_blank">https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/</A><BR /><BR />See if my webinar on Time Intelligence can help: <A href="https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184" target="_blank">https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184</A><BR /><BR /><BR />Appreciate your Kudos.</P> Wed, 29 Jul 2020 17:06:26 GMT amitchandak 2020-07-29T17:06:26Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-calculated-table-with-multiple-calculated-column-from/m-p/1259613#M20927 <P>Hello,</P><P>I am new to this. I need help to add new calculated table with multiple calculated column with DAX.</P><P>&nbsp;</P><P>I have 2 table as below:</P><P>&nbsp;</P><P>Table A:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Date A</TD><TD>List A</TD></TR><TR><TD>1/07/2020</TD><TD>Content A1</TD></TR><TR><TD>1/07/2020</TD><TD>Content A2</TD></TR><TR><TD>1/07/2020</TD><TD>Content A3</TD></TR><TR><TD>12/07/2020</TD><TD>Content A4</TD></TR><TR><TD>12/07/2020</TD><TD>Content A5</TD></TR><TR><TD>12/07/2020</TD><TD>Content A6</TD></TR><TR><TD>12/07/2020</TD><TD>Content A7</TD></TR><TR><TD>12/07/2020</TD><TD>Content A8</TD></TR><TR><TD>12/07/2020</TD><TD>Content A9</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Table B:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Date B</TD><TD>List B&nbsp;</TD></TR><TR><TD>1/07/2020</TD><TD>Content B1</TD></TR><TR><TD>1/07/2020</TD><TD>Content B2</TD></TR><TR><TD>1/07/2020</TD><TD>Content B3&nbsp;</TD></TR><TR><TD>1/07/2020</TD><TD>Content B4&nbsp;</TD></TR><TR><TD>1/07/2020</TD><TD>Content B5&nbsp;</TD></TR><TR><TD>12/07/2020</TD><TD>Content B6&nbsp;</TD></TR><TR><TD>12/07/2020</TD><TD>Content B7&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to count the content in table A and table B based on date as follow:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>List A Count</TD><TD>List B Count</TD></TR><TR><TD>1/07/2020</TD><TD>3</TD><TD>5</TD></TR><TR><TD>12/07/2020</TD><TD>6</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How to do that?<BR />Thank you.</P> Wed, 29 Jul 2020 15:42:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-calculated-table-with-multiple-calculated-column-from/m-p/1259613#M20927 armeizal 2020-07-29T15:42:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-calculated-table-with-multiple-calculated-column-from/m-p/1259618#M20928 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="249391" data-lia-user-login="armeizal" class="lia-mention lia-mention-user">armeizal</a>&nbsp;,</P><P>&nbsp;</P><P>&nbsp;</P><P><BR />Make sure you have a date calendar and it has been marked as the date in model view.<BR />Refer :<BR /><A href="https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions" target="_blank" rel="noopener">https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions</A><BR /><A href="https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi" target="_blank" rel="noopener">https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi</A><BR /><A href="https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/" target="_blank" rel="noopener">https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/</A></P><P>&nbsp;</P><P>Create 2 measurse</P><P>&nbsp;</P><P>COUNTTableA = COUNT('TableA'[ListA])</P><P>&nbsp;</P><P>CountTableB = COUNT('TableB[ListB])</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><img /><img /></P><P>&nbsp;</P><P>Regards,</P><P>Harsh Nathani</P><P>&nbsp;</P> Wed, 29 Jul 2020 15:56:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-calculated-table-with-multiple-calculated-column-from/m-p/1259618#M20928 Anonymous 2020-07-29T15:56:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-calculated-table-with-multiple-calculated-column-from/m-p/1259841#M20937 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="249391" data-lia-user-login="armeizal" class="lia-mention lia-mention-user">armeizal</a> , Create a common date table and use countrows from each table .</P> <P>&nbsp;</P> <P>To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer : <BR /><A href="https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions" target="_blank">https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions</A> <BR /><A href="https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi" target="_blank">https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi</A><BR /><A href="https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/" target="_blank">https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/</A><BR /><BR />See if my webinar on Time Intelligence can help: <A href="https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184" target="_blank">https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184</A><BR /><BR /><BR />Appreciate your Kudos.</P> Wed, 29 Jul 2020 17:06:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-calculated-table-with-multiple-calculated-column-from/m-p/1259841#M20937 amitchandak 2020-07-29T17:06:26Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-calculated-table-with-multiple-calculated-column-from/m-p/1260485#M20967 <P>Hello&nbsp;Anonymous</a>&nbsp;</P><P>It works for me, but there are blank space between 24-Jul to 30-Jul, but it wouldn't be a problem for my needs when I use this table to line chart.</P><P>&nbsp;</P><P><img /></P><P>Thank you.</P><P>&nbsp;</P> Thu, 30 Jul 2020 01:28:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-calculated-table-with-multiple-calculated-column-from/m-p/1260485#M20967 armeizal 2020-07-30T01:28:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-calculated-table-with-multiple-calculated-column-from/m-p/1260891#M20976 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="249391" data-lia-user-login="armeizal" class="lia-mention lia-mention-user">armeizal</a>&nbsp;,</P><P>&nbsp;</P><P>Thanks . If this works kindly mark this as a Solution so that it helps other community members.</P><P>&nbsp;</P><P>Cheers,</P><P>Harsh Nathani</P> Thu, 30 Jul 2020 05:53:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-new-calculated-table-with-multiple-calculated-column-from/m-p/1260891#M20976 Anonymous 2020-07-30T05:53:55Z