Month convert to bucket .

[Anonymous]

Hi ,

Below raw data is there:

I want to convert tensure month to below  Bucket

0-6
6-12
12-18
>24

Please help on this issues.

Order ID	Order Date	Ship Date	Customer Name	Category	Sub-Category	Sales	Tensure
CA-2019-114412	15-04-2019	20-04-2019	Andrew Allen	Office Supplies	Paper	15.552	5
US-2019-156909	16-07-2019	18-07-2019	Sandra Flanagan	Furniture	Chairs	71.372	2
CA-2019-107727	19-10-2019	23-10-2019	Matt Abelman	Office Supplies	Paper	29.472	4
CA-2019-120999	10-09-2019	15-09-2019	Linda Cazamias	Technology	Phones	147.168	5
CA-2019-139619	19-09-2019	23-09-2019	Erin Smith	Office Supplies	Storage	95.616	4
CA-2019-114440	14-09-2019	17-09-2019	Tracy Blumstein	Office Supplies	Paper	19.05	3
US-2019-118038	09-12-2019	11-12-2019	Ken Brennan	Office Supplies	Binders	1.248	2
US-2019-118038	09-12-2019	11-12-2019	Ken Brennan	Furniture	Furnishings	9.708	2
US-2019-118038	09-12-2019	11-12-2019	Ken Brennan	Office Supplies	Storage	27.24	2
US-2019-119662	13-11-2019	16-11-2019	Christopher Schild	Office Supplies	Storage	230.376	3
CA-2019-140088	28-05-2019	30-05-2019	Patrick O'Donnell	Furniture	Chairs	301.96	2
CA-2019-155558	26-10-2019	02-11-2019	Paul Gonzalez	Technology	Accessories	19.99	7
CA-2019-155558	26-10-2019	02-11-2019	Paul Gonzalez	Office Supplies	Labels	6.16	7
US-2019-109484	06-11-2019	12-11-2019	Roger Barcio	Office Supplies	Binders	5.682	6
CA-2019-161018	09-11-2019	11-11-2019	Parhena Norris	Furniture	Furnishings	96.53	2
CA-2019-157833	17-06-2019	20-06-2019	Katherine Ducich	Office Supplies	Binders	51.312	3
CA-2019-119004	23-11-2019	28-11-2019	Janet Martin	Technology	Accessories	74.112	5
CA-2019-119004	23-11-2019	28-11-2019	Janet Martin	Technology	Phones	27.992	5
CA-2019-119004	23-11-2019	28-11-2019	Janet Martin	Office Supplies	Art	3.304	5
CA-2019-146780	25-12-2019	30-12-2019	Cynthia Voltz	Furniture	Furnishings	41.96	5
US-2019-107272	05-11-2019	12-11-2019	Troy Staebel	Office Supplies	Binders	2.388	7
US-2019-107272	05-11-2019	12-11-2019	Troy Staebel	Office Supplies	Storage	243.992	7
US-2019-164147	02-02-2019	05-02-2019	Dorothy Wardle	Technology	Phones	59.97	3
US-2019-164147	02-02-2019	05-02-2019	Dorothy Wardle	Office Supplies	Paper	78.304	3
US-2019-164147	02-02-2019	05-02-2019	Dorothy Wardle	Office Supplies	Fasteners	21.456	3
CA-2019-106180	18-09-2019	23-09-2019	Sally Hughsby	Office Supplies	Art	8.82	5
CA-2019-106180	18-09-2019	23-09-2019	Sally Hughsby	Office Supplies	Envelopes	10.86	5
CA-2019-106180	18-09-2019	23-09-2019	Sally Hughsby	Office Supplies	Paper	143.7	5
CA-2019-155376	22-12-2019	27-12-2019	Sandra Glassco	Office Supplies	Appliances	839.43	5

Regards,

venkat

[amitchandak · Accepted solution]

@Anonymous , Try a column like

new column = switch(true()
[Tensure] <=6 , " 0 - 6",
[Tensure] <=12 , " 6-12",
[Tensure] <=18 , " 12-18",
[Tensure] <=24 , " 18-24",
">24")

or try

SEGMENTATION

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

[Anonymous]

Hi,

Below error getting

[FrankAT]

Hi @Anonymous ,

missing comma after true()!

Regards FrankAT

[Anonymous]

hI 

I am using above formula data is coming properly,

assending order or descending not coming.

Please help on this issue.

Regards,