Hi all,
Need your assistance if possible for DAX to create categories off the price range:
for example:
Category 1: $0 - $100
Category 2: $101-$200
Category 3: $201-$300
Category 4: $301-$400
Category 5: $401-$500
Category 6: $501-$600
Attached sample data for reference.
Thanks in advance!
Regards
HidayatBook1.xlsx (12.7 KB)
Plenty of content showing you exactly how to do this.
Chrs
Sam
Another one
And another
This should get you sorted I think.
Sam
Thanks Sam!
Will use the supporting table method. 
Looks the best way without adding too much memory to the fact table.
@Yatz86 Regarding the size of the column, it would be really small as there will be only 6 unique values. So it will have very minimal impact on the data stored in memory.
Yea @AntrikshSharma the easiest way was creating a calculated column, but the fact table size would grow.
No, even if you had 10 Billion rows the size wouldn’t increase much as the dictionary size of 6 words is too small, you can try to create a column in the fact table and measure the size of the column with DAX Studio and the result would be surprising. Do try it.