topic Re: Create categorys with DAX in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-categorys-with-DAX/m-p/3684763#M143120 <P>Thank you for the help. Normaly I'm sure it would have worked but sadly I only have accec to a very limited data set which prevents me from adding colums. The only thing I can do is to create meassures.</P> Wed, 07 Feb 2024 06:15:58 GMT Emmeli 2024-02-07T06:15:58Z Create categorys with DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-categorys-with-DAX/m-p/3675754#M142698 <P>Hi&nbsp;</P><P>I would love some help with a problem of mine.&nbsp;</P><P>I have this data with the account and the sum column. I would like to create a "category" column with the help of DAX.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>New column "category"</TD><TD>&nbsp;</TD><TD>Account</TD><TD>&nbsp;</TD><TD>sum</TD></TR><TR><TD>Stockholm</TD><TD>&nbsp;</TD><TD>30100</TD><TD>&nbsp;</TD><TD>1100</TD></TR><TR><TD>Stockholm</TD><TD>&nbsp;</TD><TD>30106</TD><TD>&nbsp;</TD><TD>45456</TD></TR><TR><TD>New York</TD><TD>&nbsp;</TD><TD>30110</TD><TD>&nbsp;</TD><TD>122354</TD></TR><TR><TD>New York</TD><TD>&nbsp;</TD><TD>30112</TD><TD>&nbsp;</TD><TD>565789</TD></TR><TR><TD>Stockholm</TD><TD>&nbsp;</TD><TD>30113</TD><TD>&nbsp;</TD><TD>764866</TD></TR><TR><TD>Stockholm</TD><TD>&nbsp;</TD><TD>30120</TD><TD>&nbsp;</TD><TD>1025033</TD></TR><TR><TD>Stockholm</TD><TD>&nbsp;</TD><TD>30121</TD><TD>&nbsp;</TD><TD>1285199</TD></TR><TR><TD>Stockholm</TD><TD>&nbsp;</TD><TD>30122</TD><TD>&nbsp;</TD><TD>1545366</TD></TR><TR><TD>Stockholm</TD><TD>&nbsp;</TD><TD>30123</TD><TD>&nbsp;</TD><TD>1805532</TD></TR><TR><TD>Stockholm</TD><TD>&nbsp;</TD><TD>30124</TD><TD>&nbsp;</TD><TD>2065699</TD></TR><TR><TD>Stockholm</TD><TD>&nbsp;</TD><TD>30190</TD><TD>&nbsp;</TD><TD>2065699</TD></TR><TR><TD>Stockholm</TD><TD>&nbsp;</TD><TD>30199</TD><TD>&nbsp;</TD><TD>565</TD></TR><TR><TD>Boston</TD><TD>&nbsp;</TD><TD>30300</TD><TD>&nbsp;</TD><TD>2065699</TD></TR><TR><TD>Boston</TD><TD>&nbsp;</TD><TD>30310</TD><TD>&nbsp;</TD><TD>1033132</TD></TR><TR><TD>Boston</TD><TD>&nbsp;</TD><TD>30399</TD><TD>&nbsp;</TD><TD>826618,4</TD></TR><TR><TD>Los Angeles</TD><TD>&nbsp;</TD><TD>30400</TD><TD>&nbsp;</TD><TD>620105,1</TD></TR><TR><TD>Los Angeles</TD><TD>&nbsp;</TD><TD>30410</TD><TD>&nbsp;</TD><TD>413591,7</TD></TR><TR><TD>Los Angeles</TD><TD>&nbsp;</TD><TD>30499</TD><TD>&nbsp;</TD><TD>207078,4</TD></TR><TR><TD>Florida</TD><TD>&nbsp;</TD><TD>30500</TD><TD>&nbsp;</TD><TD>565</TD></TR><TR><TD>Florida</TD><TD>&nbsp;</TD><TD>30510</TD><TD>&nbsp;</TD><TD>-205948</TD></TR><TR><TD>Florida</TD><TD>&nbsp;</TD><TD>30520</TD><TD>&nbsp;</TD><TD>-412462</TD></TR><TR><TD>Florida</TD><TD>&nbsp;</TD><TD>30590</TD><TD>&nbsp;</TD><TD>-618975</TD></TR><TR><TD>Florida</TD><TD>&nbsp;</TD><TD>30599</TD><TD>&nbsp;</TD><TD>-825488</TD></TR><TR><TD>New orleans</TD><TD>&nbsp;</TD><TD>30800</TD><TD>&nbsp;</TD><TD>-1032002</TD></TR><TR><TD>New orleans</TD><TD>&nbsp;</TD><TD>30810</TD><TD>&nbsp;</TD><TD>-1238515</TD></TR><TR><TD>New orleans</TD><TD>&nbsp;</TD><TD>30820</TD><TD>&nbsp;</TD><TD>-1445028</TD></TR><TR><TD>New orleans</TD><TD>&nbsp;</TD><TD>30870</TD><TD>&nbsp;</TD><TD>500</TD></TR><TR><TD>New orleans</TD><TD>&nbsp;</TD><TD>30899</TD><TD>&nbsp;</TD><TD>456</TD></TR><TR><TD>San Diego</TD><TD>&nbsp;</TD><TD>31000</TD><TD>&nbsp;</TD><TD>964127</TD></TR><TR><TD>San Diego</TD><TD>&nbsp;</TD><TD>31001</TD><TD>&nbsp;</TD><TD>1686869</TD></TR><TR><TD>San Diego</TD><TD>&nbsp;</TD><TD>31010</TD><TD>&nbsp;</TD><TD>2409611</TD></TR><TR><TD>San Diego</TD><TD>&nbsp;</TD><TD>31011</TD><TD>&nbsp;</TD><TD>3132354</TD></TR><TR><TD>San Diego</TD><TD>&nbsp;</TD><TD>31020</TD><TD>&nbsp;</TD><TD>3855096</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>So that I can use the category to create this</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 02 Feb 2024 14:18:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-categorys-with-DAX/m-p/3675754#M142698 Emmeli 2024-02-02T14:18:32Z Re: Create categorys with DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-categorys-with-DAX/m-p/3676692#M142761 <P>What would be the rules for the creation of this category?</P> Sat, 03 Feb 2024 02:55:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-categorys-with-DAX/m-p/3676692#M142761 lbendlin 2024-02-03T02:55:43Z Re: Create categorys with DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-categorys-with-DAX/m-p/3679449#M142873 <P>I'm thinking something like this&nbsp;</P><P>&nbsp;</P><P>Sum of "sum" column with&nbsp;accountnumber (30100-30106 and 30113-30199 )= Stockholm</P><P>Sum of "sum" column with&nbsp;accountnumber 30110-30112 = New York</P><P>Sum of "sum" column with&nbsp;accountnumber 30300-30399 = Boston</P><P>Sum of "sum" column with&nbsp;accountnumber 30400-30499 = Los Angeles</P><P>Sum of "sum" column with&nbsp;accountnumber 30500-30599 = Florida</P><P>Sum of "sum" column with&nbsp;accountnumber 30800-30899 = New Orleans</P><P>Sum of "sum" column with&nbsp;accountnumber 31000- 31020 = San Diego</P><P>&nbsp;</P> Mon, 05 Feb 2024 06:59:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-categorys-with-DAX/m-p/3679449#M142873 Emmeli 2024-02-05T06:59:19Z Re: Create categorys with DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-categorys-with-DAX/m-p/3680850#M142936 <P>I'll show you two options.&nbsp; One is using the existing data to create groups, the other is using a calculated column with the ranges.</P> <DIV id="tinyMceEditor_8127f79714634flbendlin_0" class=""><BR /> <DIV class=""> <DIV class=""> <DIV class=""> <DIV class="" style="width: 100%;"><img /> <P>&nbsp;</P> <BR /> <P>&nbsp;</P> <P>&nbsp;</P> </DIV> </DIV> </DIV> </DIV> </DIV> Mon, 05 Feb 2024 17:02:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-categorys-with-DAX/m-p/3680850#M142936 lbendlin 2024-02-05T17:02:14Z Re: Create categorys with DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-categorys-with-DAX/m-p/3684763#M143120 <P>Thank you for the help. Normaly I'm sure it would have worked but sadly I only have accec to a very limited data set which prevents me from adding colums. The only thing I can do is to create meassures.</P> Wed, 07 Feb 2024 06:15:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-categorys-with-DAX/m-p/3684763#M143120 Emmeli 2024-02-07T06:15:58Z