Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
256
Views
Topic starter
Hi
I m facing problem in Power Query.
| When in Power Query I pivot the Dscription Column with OfftakeQty then the result according to offtake Quantity is ok but t offtake amount is wrong. | |||||
|
So How I can get correct values of (OfftakeQTY & OfftakeAmt )
File is attached
Thanks |
Posted : 19/06/2019 6:29 am
Hi Nadeem,
Thanks for sharing your file. Before you Pivot the data, add an Index column (starting at zero or 1, it doesn't matter). Then Pivot the data. Your OfftakeAmt should be in the correct order.
See attached. You can remove the Index column once you've pivoted the data.
Mynda
Posted : 19/06/2019 7:41 am
Topic starter
Problem Solved
I'm really thankful to you
Posted : 19/06/2019 8:29 am
