topic Total by year. Values in 2 columns in DAX Commands and Tips

Total by year. Values in 2 columns

Johnny1981 — Fri, 20 Sep 2019 20:47:48 GMT

Hi, I have a table like this, where the amounts are divided into 2 diferents columns.

First Payment	Year 1° Payment	Second Payment	Year 2° Payment
$ 43.499,00	2013	$ 43.501,00	2013
$ 73.140,00	2013	$ 73.141,00	2013
$ 87.686,00	2013	$ 87.687,00	2013
$ 83.064,00	2013	$ 83.064,00	2013
$ 75.875,00	2013	$ 75.875,00	2013
$86.500,00	2013	$ 86.500,00	2013
$ 74.027,00	2013	$ 74.027,00	2013
$ 90.725,00	2013	$ 90.726,00	2013
$ 65.197,00	2013	$ 65.197,00	2013
$ 65.404,00	2013	$ 65.404,00	2013
$ 80.000,00	2013	$ 80.000,00	2013
$ 235.000,00	2014	$ 235.000,00	2014
$ 205.000,00	2014	$ 205.000,00	2014

I wanna get the total by year

Year	Total Payment
2013	$ 1.650.239
2014	$ 880.000

Thanks !!

Re: Total by year. Values in 2 columns

MattAllington — Fri, 20 Sep 2019 22:12:14 GMT

Reshape you’re table in power query before you load it. Set it up as

paymentyear, payment number, amount

then it is eaSy

Re: Total by year. Values in 2 columns

Johnny1981 — Fri, 20 Sep 2019 23:59:56 GMT

Thank you very much for your answer. The table in my example is only part of a very large table, in which I cannot make the change you say. The table has one row for each company.