How to add two rows?

Question

Hello All!!&nbsp;I'm quite new to PQ. I working with not very large dataset and I'm facing a bit challenge.I have one query which looks like this:&nbsp;Column 1 &nbsp; Column 240001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Amount 140002 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Amount 240003 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Amount 3&nbsp;I have another query where i have a mapping table for Column 1.Let's say it looks like this:&nbsp;Column 1 &nbsp; &nbsp; &nbsp; Column 240001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value 140002 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value 240003 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value 3&nbsp;In my pivot table i need t retain Value 1, Value 2 and Value 3 but I also need "something" (I guess not a measure) which would allow me to add Value 2 and Value 3.&nbsp;How would I solve it?&nbsp;&nbsp;Appreciate help!!

tg20188 · Answer

One clarifcation Value 1, Value 2 and Value 3 are not numbers these are basically labels. Sorry for confusion!

knp · Answer

Hi&nbsp;Tg20188&nbsp;- can you please place some actual sample data and desired output to give a better understanding of what you're trying to achieve?
&nbsp;

v-yingjl · Answer

Hi&nbsp;Tg20188&nbsp;,
In my pivot table i need t retain Value 1, Value 2 and Value 3 but I also need "something" (I guess not a measure) which would allow me to add Value 2 and Value 3.
Could you please consider providing more detail about it? For example, which is your pivot table, the result table? or the source table; how to understand 'add Value 2 and Value 3' since the column is not number type etc.
&nbsp;
In addition, if you can provide expected output, it would help better.&nbsp;Please see this post regarding How to Get Your Question Answered Quickly:https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
&nbsp;
Best Regards,Community Support Team _ Yingjie Li
&nbsp;

tg20188 · Answer

Hello everyone,&nbsp;apologize I didn't provide responses.I wanted to attach an example.&nbsp;- "Financial data" tab is my dataset- "Mapping" is basically mapping of Account #s in "Financial data"- Each account has one of two values assigned: "Gross" or "Ceded"&nbsp;When building Pivot table i want to have Gross and Ceded values in rows and Accounts in columns. This works fine. What I'm struggling with is how to add "Gross" and "Ceded" aggregations to calculate "Net" (which is sum of "Gross" and "Ceded").I also added to the attached file "Output" tab which is just static presentation what i want to achieve.&nbsp;let me know if this support helps. and thank you in advance for help 🙂&nbsp;https://docs.google.com/spreadsheets/d/1AdEmeik50VrC-5ZQOz2EbJc00lCpXXu0/edit?usp=sharing&amp;ouid=111159354396280446927&amp;rtpof=true&amp;sd=true&nbsp;

knp · Answer

Still need more detail.
From the mapping table, an account appears to be one or the other, never both Gross and Ceded.
So from what I can see in your sample data this would be your output...

&nbsp;
Account 1
Account 2
Account 3
Account 4
Account 5
Account 6

Gross
100
100
-20
&nbsp;
&nbsp;
&nbsp;

Ceded
&nbsp;
&nbsp;
&nbsp;
30
150
200

Net
100
100
-20
-30
-150
-200&nbsp;

&nbsp;
What am I missing?

Forum Discussion

How to add two rows?

5 Replies

Related content

Power Query Add rows of zero amount

Add duplicate row based on column

Add subtotal Rows

Add Custom Row (Table.InsertRow)

Add Rows - Loop

	Account 1	Account 2	Account 3	Account 4	Account 5	Account 6
Gross	100	100	-20
Ceded				30	150	200
Net	100	100	-20	-30	-150	-200