I have a table with a column and values. I'm trying to group the values into group ranges. For exmple
and im looking for an outcome like this.
Go to Solution.
Probably the easiest is to create add a calculated column with the range:
Table1[Amount] <= 10000, "Between 1 and 10000",
Table1[Amount] <= 20000, "Between 10001 and 20000",
Table1[Amount] <= 30000, "Between 20001 and 30000",
then use it in a matrix visual with a simple COUNT measure
View solution in original post
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!