Forum Discussion

Emmeli's avatar
Emmeli
Frequent Visitor
2 years ago
Solved

Create categorys with DAX

Hi  I would love some help with a problem of mine.  I have this data with the account and the sum column. I would like to create a "category" column with the help of DAX.   New column "categor...
  • lbendlin's avatar
    lbendlin
    2 years ago

    I'll show you two options.  One is using the existing data to create groups, the other is using a calculated column with the ranges.


     


     

     

lbendlin's avatar
lbendlin
Super User
2 years ago

What would be the rules for the creation of this category?

Emmeli's avatar
Emmeli
Frequent Visitor
2 years ago

I'm thinking something like this 

 

Sum of "sum" column with accountnumber (30100-30106 and 30113-30199 )= Stockholm

Sum of "sum" column with accountnumber 30110-30112 = New York

Sum of "sum" column with accountnumber 30300-30399 = Boston

Sum of "sum" column with accountnumber 30400-30499 = Los Angeles

Sum of "sum" column with accountnumber 30500-30599 = Florida

Sum of "sum" column with accountnumber 30800-30899 = New Orleans

Sum of "sum" column with accountnumber 31000- 31020 = San Diego

 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    I'll show you two options.  One is using the existing data to create groups, the other is using a calculated column with the ranges.