Dax Help For Unique Table Creation

[lg1551]

I have a measure that sums values for 5 product categories.

I want to take the MIN of that measure, the MAX of that measure, and create a table.

The table will contain the MIN value as the bottom row (or top row) and the MAX value as top row (or bottom row). I need a row for each value in between so that all numbers between the MIN and the MAX are accounted for and represented in the table.

Example data:

Category     Value

Category 1    20

Category 2    18

Category 3    15

Category 4    10

Category 5    02

Table to Generate:

Value

20

19

18

17

16

15

14

13

12

11

10

9

8

7

6

5

4

3

2

[amitchandak · Accepted solution]

@lg1551 , a new table

= generateseries(Min(Category[Value]) ,Max(Category[Value]) ,1)

[lg1551]

Thank you!