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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Conditional Distinct Count measure in excel pivot table
- Thread starter MrBK
- Start date
Excel Facts
Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Similar threads
- Replies
- 0
- Views
- 389
- Replies
- 0
- Views
- 193
- Replies
- 1
- Views
- 272
- Replies
- 0
- Views
- 420
- Replies
- 1
- Views
- 469
