I have created a small database from multiple excel files in a folder using power query.
The column A contains the source name of the excel sheets starting from 01 to 31 which is equal to days in a month so if you have completed 31 days all of the information in between these dates are compiled into one sheet. The total data is then added to the data model and a pivot table will be created on a separate sheet, there are two pivot tables with the same source one is for the whole total with duplicates and the other is for distinct values only.
On the 2nd pivot, how am i able to count the distinct value with the highest source name which is found in the first column as a measure?
Bookmarks