Hello,
I would like to use the table in columns a, b, c to generate a pivot table like that in column j and y.
I know that a DAX formula is needed to be able to display text in pivot tables, but I'm a beginner and so far I have not found the right formula. A little help if you can?
Note: I use Excel 2013, not PRO version. But I installed the powerquery addin. Unfortunately, I can not use powerpivot.
Format your source data as a table.
Use Power Query to query that table, and Load To Data Model.
Insert a pivot table based on the Data Model.
Right click on Data Model table in pivot list, and Add Measure.
Add a measure:
Use this measure in your pivot table.
Please Login or Register to view this content.
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...
olly thx. I have used you formula in measure. Only one question" why the order of order isnt the same?
Capture.PNG
Last edited by mlaxx; 06-12-2019 at 02:12 PM.
Invalid attachment. Not sure what you mean?
the orders c1 c2 ..in pivot table dont remain ordered c1 c2 ...c18
No, they're sorted alphabetically.
ok. i supose a easy solution for this problem isnt. thx olly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks