Hello All,
I am beginner in PowerQuery, but I'm trying to make some reports from XML files. I almost achieved my goals, but there is still one thing I cannot solve.
In my XML there is Attribute: A00 (duty) and B00 (tax), assigned to given item. In order not to duplicate the value of the invoice, I have to either put filters on the report to show only A00 or only B00, otherwise when there's no filters on that column, I'd have doplicated a lot of things.
I needed to use pivots, but once I did it, I have issue like on below table. Unfortunately I am not authorized yet to attach anything
Eventually, I need changelayout of my report from the first table to the second table of the screenshot.
Sorry for uploading photo on external server, but I wasn't able to attach anything in this thread.
For any advices I'd be very grateful. Please keep in mind, that I'm "working" in excel since few weeks, I'm really beginner.
MRN Invoice value Currency Code ROE Kind of Tax TAX Base Rate Amount of A00 Amount of B00
20PL322080I0483690 116415,55 USD 44440000 3,9556 A00 433715 4,5 19517 null
20PL322080I0483690 116415,55 USD 44440000 3,9556 B00 464980 23 null 106945
20PL322080I0483690 116415,55 USD 55550000 3,9556 A00 69635 4,5 3134 null
20PL322080I0483690 116415,55 USD 55550000 3,9556 B00 74739 23 null 17190
MRN Invoice value Currency ROE Code Duty base VAT Base Duty VAT
20PL322080I0483690 116415,55 USD 3,9556 44440000 433715 464980 19517 106945
20PL322080I0483690 116415,55 USD 3,9556 55550000 69635 74739 3134 17190
Bookmarks