topic Re: Create summarize table with Dax in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-summarize-table-with-Dax/m-p/1961280#M42902 <P><img /></P><P>&nbsp;</P><DIV><DIV><STRONG><EM>Result Table = </EM></STRONG></DIV><DIV><EM>SUMMARIZE (</EM></DIV><DIV><EM>FILTER (</EM></DIV><DIV><EM>CROSSJOIN (</EM></DIV><DIV><EM>TableB,</EM></DIV><DIV><EM>TableA</EM></DIV><DIV><EM>),</EM></DIV><DIV><EM>TableA[Date] &gt;= TableB[Start]</EM></DIV><DIV><EM>&amp;&amp; TableA[Date] &lt;= TableB[End]</EM></DIV><DIV><EM>&amp;&amp; TableA[DayName] &lt;&gt; TableB[Exclude]</EM></DIV><DIV><EM>&amp;&amp; TableA[Weekend] &lt;&gt; TableB[Exclude]</EM></DIV><DIV><EM>),</EM></DIV><DIV><EM>TableB[Category],</EM></DIV><DIV><EM>TableA[Date]</EM></DIV><DIV><EM>)</EM></DIV><DIV>&nbsp;</DIV><DIV><SPAN><A href="https://www.dropbox.com/s/z2v5zarcevs81z7/choiv2.pbix?dl=0" target="_self">https://www.dropbox.com/s/z2v5zarcevs81z7/choiv2.pbix?dl=0</A>&nbsp;</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV> Fri, 16 Jul 2021 06:59:15 GMT Jihwan_Kim 2021-07-16T06:59:15Z Create summarize table with Dax https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-summarize-table-with-Dax/m-p/1961089#M42895 <P>Hello.&nbsp;<BR />Could you help me ? I can't know that by using DAX.&nbsp;</P><P>TabelA</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>DayName</TD><TD>Weekend</TD></TR><TR><TD>2021/7/1</TD><TD>Fri</TD><TD>&nbsp;</TD></TR><TR><TD>2021/7/2</TD><TD>Sat</TD><TD>Y</TD></TR><TR><TD>2021/7/3</TD><TD>Sun</TD><TD>Y</TD></TR><TR><TD>2021/7/4</TD><TD>Mon</TD><TD>&nbsp;</TD></TR><TR><TD>2021/7/5</TD><TD>Tue</TD><TD>&nbsp;</TD></TR><TR><TD>2021/7/6</TD><TD>Wed</TD><TD>&nbsp;</TD></TR><TR><TD>2021/7/7</TD><TD>Thu</TD><TD>&nbsp;</TD></TR><TR><TD>2021/7/8</TD><TD>Fri</TD><TD>&nbsp;</TD></TR><TR><TD>2021/7/9</TD><TD>Sat</TD><TD>Y</TD></TR><TR><TD>2021/7/10</TD><TD>Sun</TD><TD>Y</TD></TR><TR><TD>2021/7/11</TD><TD>Mon</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>TableB</P><TABLE border="1"><TBODY><TR><TD>Category</TD><TD>Start</TD><TD>End</TD><TD>Exclude</TD></TR><TR><TD>A</TD><TD>2021/7/1</TD><TD>2021/7/5</TD><TD>Sun</TD></TR><TR><TD>B</TD><TD>2021/7/4</TD><TD>2021/7/11</TD><TD>Weekend</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Resutl</P><TABLE border="1"><TBODY><TR><TD>Category</TD><TD>Date</TD></TR><TR><TD>A</TD><TD>2021/7/1</TD></TR><TR><TD>A</TD><TD>2021/7/2</TD></TR><TR><TD>A</TD><TD>2021/7/4</TD></TR><TR><TD>A</TD><TD>2021/7/5</TD></TR><TR><TD><STRONG>B</STRONG></TD><TD><STRONG>2021/7/4</STRONG></TD></TR><TR><TD>B</TD><TD>2021/7/5</TD></TR><TR><TD>B</TD><TD>2021/7/6</TD></TR><TR><TD>B</TD><TD>2021/7/7</TD></TR><TR><TD>B</TD><TD>2021/7/8</TD></TR><TR><TD>B</TD><TD>2021/7/11</TD></TR></TBODY></TABLE> Fri, 16 Jul 2021 04:27:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-summarize-table-with-Dax/m-p/1961089#M42895 ChoiJunghoon 2021-07-16T04:27:55Z Re: Create summarize table with Dax https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-summarize-table-with-Dax/m-p/1961237#M42899 <P><img /></P> <P>&nbsp;</P> Fri, 16 Jul 2021 06:39:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-summarize-table-with-Dax/m-p/1961237#M42899 wdx223_Daniel 2021-07-16T06:39:30Z Re: Create summarize table with Dax https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-summarize-table-with-Dax/m-p/1961249#M42901 <P>Thank you so much!!&nbsp;</P> Fri, 16 Jul 2021 06:44:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-summarize-table-with-Dax/m-p/1961249#M42901 ChoiJunghoon 2021-07-16T06:44:32Z Re: Create summarize table with Dax https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-summarize-table-with-Dax/m-p/1961280#M42902 <P><img /></P><P>&nbsp;</P><DIV><DIV><STRONG><EM>Result Table = </EM></STRONG></DIV><DIV><EM>SUMMARIZE (</EM></DIV><DIV><EM>FILTER (</EM></DIV><DIV><EM>CROSSJOIN (</EM></DIV><DIV><EM>TableB,</EM></DIV><DIV><EM>TableA</EM></DIV><DIV><EM>),</EM></DIV><DIV><EM>TableA[Date] &gt;= TableB[Start]</EM></DIV><DIV><EM>&amp;&amp; TableA[Date] &lt;= TableB[End]</EM></DIV><DIV><EM>&amp;&amp; TableA[DayName] &lt;&gt; TableB[Exclude]</EM></DIV><DIV><EM>&amp;&amp; TableA[Weekend] &lt;&gt; TableB[Exclude]</EM></DIV><DIV><EM>),</EM></DIV><DIV><EM>TableB[Category],</EM></DIV><DIV><EM>TableA[Date]</EM></DIV><DIV><EM>)</EM></DIV><DIV>&nbsp;</DIV><DIV><SPAN><A href="https://www.dropbox.com/s/z2v5zarcevs81z7/choiv2.pbix?dl=0" target="_self">https://www.dropbox.com/s/z2v5zarcevs81z7/choiv2.pbix?dl=0</A>&nbsp;</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV> Fri, 16 Jul 2021 06:59:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-summarize-table-with-Dax/m-p/1961280#M42902 Jihwan_Kim 2021-07-16T06:59:15Z