![]() ![]() ![]() When you select this option, Excel treats the data as being loaded into Power Pivot, as opposed into the older Pivot Table. From Excel 2013 onward, when creating a Pivot Table form any set of data, there is an option to Add this data to Data Model. With the advances made by Microsoft with Power Pivot, and DAX (Data Expressions) formulae, which are more powerful than the inbuilt Excel functions, there is a way of obtaining a Distinct Count. I’ll hand things over to Roger, so he can describe the steps. Now Roger has added another technique that you can use, in Excel 2013 and later. Add a calculated column to the source data (much slower).Create a Pivot of a Pivot Tables results (fast). ![]() In a previous article, Roger Govier showed us a couple of different ways to get a Unique count with a Pivot Table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |