Hello,
I need assistance 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. Thanks for your assistance.
I need assistance 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. Thanks for your assistance.