Creating Tables

[EveryUser]

Hello, I'm currently working on a project where I have to create/modify a table that I have to put down values where I have to substract using 2 values located in the same column. However I'm currently having difficulties on doing so is there a sollution/assistance for this problem? (Note: The table contains 22 rows in which row 1 and row 12 needs to be substracted, same applies for row 2 and 13, 3 and 14...)

Thank you so much for your time

[v-rongtiep-msft]

Hi @EveryUser ,

I have created a simple samplem please refer to my pbix file to see if it helps you.

Create a measure.

Measure = var _value=CALCULATE(MAX('table'[Column 1 ]),FILTER(ALL('table'),'table'[Index]=SELECTEDVALUE('table'[Index])+4))
return 
MAX('table'[Column 1 ])-_value

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[EveryUser]

For example in this table a column needs to generated by substracting sample 1 in column 1 and sample 5 in column 1 which also applies for 2-6, 3-7 and 4-8. And another column needs to be generated with the same application but on column 2. 

	Column 1	Column 2
Sample 1	5	3
Sample 2	2	1
Sample 3	1	3
Sample 4	0	4
Sample 5	4	8
Sample 6	2	5
Sample 7	1	2
Sample 8	7	1

[FreemanZ]

hi @EveryUser 

could you also paste the expected result column? for instance, where do you plan to put the subtraction result of sample 1 and 5?

[EveryUser]

The result will be 

	Column 1	Column 2
Difference Between 1 and 5	1	-5
Difference Between 2 and 6	0	-4
Difference Between 3 and 7	0	2
Difference Between 4 and 8	-7	3

[EveryUser]

Values for column 1 are 1,0,0,-7

[EveryUser]

For some reason the values on the first column are so closely together with sample titles but the values for the first column are 5,2,1,0,4,2,1,7 respectively

[FreemanZ]

hi @EveryUser 

Seems doable. could you paste some sample data?