https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Calculated-Table/m-p/3285702#M122140 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="340200" data-lia-user-login="botaac" class="lia-mention lia-mention-user">botaac</a>&nbsp;simpe click add new table and use ADDCOLUMNS (SUMMARIZE pattern with your columns and measures like&nbsp;<A href="https://learn.microsoft.com/en-us/dax/addcolumns-function-dax?WT.mc_id=DP-MVP-4025372" target="_self">https://learn.microsoft.com/en-us/dax/addcolumns-function-dax?WT.mc_id=DP-MVP-4025372</A>&nbsp;</P><P>I hope this help</P> Thu, 15 Jun 2023 10:13:21 GMT some_bih 2023-06-15T10:13:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Calculated-Table/m-p/3283834#M122026 <P>I am trying to take the sample dataset:</P><TABLE border="1"><TBODY><TR><TD>ID</TD><TD>Location</TD><TD>Number Bracket</TD></TR><TR><TD>123</TD><TD>North America</TD><TD>$101-$250</TD></TR><TR><TD>233</TD><TD>North America</TD><TD>$251-$500</TD></TR><TR><TD>433</TD><TD>EMEA</TD><TD>$101-$250</TD></TR><TR><TD>697</TD><TD>APAC</TD><TD>$501-$1000</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And create a calculated table in DAX that performs the following:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Index</TD><TD>Bracket</TD><TD>North America</TD><TD>APAC</TD><TD>EMEA</TD></TR><TR><TD>1</TD><TD>$101-$250</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>2</TD><TD>$251-$500</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>3</TD><TD>$501-$1000</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Essentially creating a pivot table. Let me know if this is possible. Thank you!</P> Wed, 14 Jun 2023 13:51:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Calculated-Table/m-p/3283834#M122026 botaac 2023-06-14T13:51:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Calculated-Table/m-p/3285702#M122140 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="340200" data-lia-user-login="botaac" class="lia-mention lia-mention-user">botaac</a>&nbsp;simpe click add new table and use ADDCOLUMNS (SUMMARIZE pattern with your columns and measures like&nbsp;<A href="https://learn.microsoft.com/en-us/dax/addcolumns-function-dax?WT.mc_id=DP-MVP-4025372" target="_self">https://learn.microsoft.com/en-us/dax/addcolumns-function-dax?WT.mc_id=DP-MVP-4025372</A>&nbsp;</P><P>I hope this help</P> Thu, 15 Jun 2023 10:13:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Calculated-Table/m-p/3285702#M122140 some_bih 2023-06-15T10:13:21Z