Forum Discussion
Merging two rows into one and using new rows in a graph
I am trying to combine rows "." and ".." into one. I would like to add up their sale numbers as well and rename the new column to "EquipmentSales" instead of the dots. I have about 4 tables ...
amitchandak
Super User
Super UserAnonymous , You should sales table where you can have an additional column where you have . and .. as . and rest all are same.
or use segmentation or binning
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
amitchandak Thank you!
I tried grouping them for some reason the "group" is not an option. Any ideas?
Anything is helpful. Thank you!