Summarize min date in data model pivot

[howesmr]

Hello,

I have a need in a pivot summarize one column by min and max date and another column by distinct count. In a default pivot the min and max date work fine but I cant get distinct count. So when I create the pivot in data model mode the distinct count works fine but now I can summarize my min and max date. It says "We Cant summarize this field with Min because its not a supported calculation for Date data types.

So I have had to create two separate pivot tables and use a look up formula next to the results of one pivot to bring in the distinct count from the other. My file was already huge and bogged down editing but with the addition distinct count pivot the size is far bigger and slower.

So I either need a way to get distinct count as an additional column in my data based on two criteria so that way the normal pivot will work and i can just use average or min as all the distinct counts will be the same when these two criteria are the same or get min date in a data model pivot.

Thanks in advance