Substracting 2 rows.

[Anonymous]

Hello, 

I have a table with 2 rows, I want a 3rd row with the difference in value of the first 2 rows, How can I do this in power query editor ?

[Anonymous]

Hi, I need the difference of 2 rows and not columns..I am able to do it for columns, in my case i have a horizontally long table with 2 rows giving the percentage of sales of 2 countries(hence 2 rows), for 5 different categories(implying 5 Columns), I need a 3rd row showing the differnece in sales% between 2 countries..

[alosada]

Could you give me an  example of the table? in that way i can construct a solid answer for your question

[alosada]

Hi,

you should create a personalized column (in add column menu of power query editor) and there you should add the desired formula. In your case, I think it would be the following:

[Column1]-[Column2]