Forum Discussion
How to add two rows?
Hello All!! 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: Column 1 Column 2 40001 Amount 1 ...
Hi Tg20188 ,
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.
In addition, if you can provide expected output, it would help better. 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
Best Regards,
Community Support Team _ Yingjie Li