[ Reserver Measure Index ]

[phamtrinh96]

Hi , I have table , there are Measure and Amount_Day. I caculated column Measure and I create column " Measure_Desire " resver column Mersure . Example Image. I want to solution this problem. Thanks you 

Measure	Amount_Day	Measure_Desire
1	23000	8
2	34555	7
3	23444	6
4	23422	5
5	34222	4
6	12333	3
7	34332	2
8	34553	1

[phamtrinh96]

Hi , I have table , there are Measure and Amount_Day. I caculated column Measure and I create column " Measure_Desire " resver column Mersure . Example Image. I want to solution this problem. Thanks you 

Measure	Amount_Day	Measure_Desire
1	23000	8
2	34555	7
3	23444	6
4	23422	5
5	34222	4
6	12333	3
7	34332	2
8	34553	1

[Anonymous · Accepted solution]

Hi

You have to create a calculated column, this is the sintax:

Calculated Column = MAX(Table[Measure])+1-Table[Measure]

The result: