Forum Discussion

lg1551's avatar
lg1551
Resolver II
4 years ago
Solved

Dax Help For Unique Table Creation

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

2 Replies