I have searching a lot in the messages but could not find a solution to my problem which I feel is pretty straight forward
Here below a simplified extract from a table I want to work on
I would want to transform that table having 7 columns
Item / Sum Qty for FY=18 / Sum Sales for FY=18 / Sum Costs for FY=18 / Sum Qty for FY=19 / Sum Sales for FY=19 / Sum Costs for FY=19
I tried pivoting/unpivoting
I tried with List.Sum(Table.SelectRows
but wasn't able to achieve the result
Thanks in advance for your support
I have a little confused about your requirement.
Is the image you shared your data sample?
If it is convenient, could you share your desired output so that I can understand your requirement better and get the solution?
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.