I need help writing a distinctcount calculated measure based on conditional criteria in an excel pivot table. The data source is excel data model table titled '2023 2022 data. The two columns I'm trying to reference are the [customer name] and the [year]. The conditional formula would count distinct customers based on year = 2023. Any assistance would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Distinct Count measure in excel pivot table
- Thread starter MrBK
- Start date
