I have attached a spreadsheet which is a simplified example of my raw data and also my desired output. I need to build a list which shows the name of a product in a cell in every year that it is sold. But I need the name to appear in a pivot. I have only been able to get the number field to appear in the value part of the pivot
Format your source data as a table, then use this power query to normalise, and load to the data model:
Now add a measure to your data model:
Please Login or Register to view this content.
This will then list the product names for products with sales. It aggregates, so reports the relevant list, when the evaluation context has sales for more than one product:Please Login or Register to view this content.
Capture.PNG
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks