Forum Discussion
Solved
How to create dynamic data bin using Dax
Hi My data structure is as follow : order id sale_price 1 $35 2 $22 3 $7 I am looking for a way to create calculate column with D...
The following should do the sort of thing you want:
= SWITCH(TRUE(), Table1[sale_price] < 5, "$<5", AND(Table1[sale_price]>=5, Table1[sale_price]<10), "$05-10", AND(Table1[sale_price]>=10, Table1[sale_price]<20), "$10-20", AND(Table1[sale_price]>=20, Table1[sale_price]<30), "$20-30", AND(Table1[sale_price]>=30, Table1[sale_price]<40), "$30-40", "$40+")
But, for a more robust solution that is maintainable, sortable etc., see posts such as https://blogs.msdn.microsoft.com/analysisservices/2014/06/05/bucketing-values-in-dax/ and the Marco Russo links in the comments at the end of tha tblog.
The following should do the sort of thing you want:
= SWITCH(TRUE(), Table1[sale_price] < 5, "$<5", AND(Table1[sale_price]>=5, Table1[sale_price]<10), "$05-10", AND(Table1[sale_price]>=10, Table1[sale_price]<20), "$10-20", AND(Table1[sale_price]>=20, Table1[sale_price]<30), "$20-30", AND(Table1[sale_price]>=30, Table1[sale_price]<40), "$30-40", "$40+")
But, for a more robust solution that is maintainable, sortable etc., see posts such as https://blogs.msdn.microsoft.com/analysisservices/2014/06/05/bucketing-values-in-dax/ and the Marco Russo links in the comments at the end of tha tblog.