Forum Discussion

ksfx77's avatar
ksfx77
Icon for Helper I rankHelper I
4 years ago
Solved

How to get a distinctcount per day over a date range

Hi all,   Hopefully an easy one for a Friday! 🙂   I am performing a distinct count over various date ranges in a measure, but I need the result returned to be based on the daily distinct count p...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    ksfx77 that makes a lot more sense.  Okay, all you need to do is change the way in which you are "counting".  For example, right now, you're using userGuid as the distinctcount.  If you concatenate userGuid with the Date/Time field, then ran a distinctcount on the new column, would that provide you with what you want?  The only difference with your VAR _CountLastXDays would be that you use 'Table1'[New Column] rather than [userGuid].

     

    Let me know if this is kind of what you're looking for?


    Thanks
    Theo

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

ksfx77 that makes a lot more sense.  Okay, all you need to do is change the way in which you are "counting".  For example, right now, you're using userGuid as the distinctcount.  If you concatenate userGuid with the Date/Time field, then ran a distinctcount on the new column, would that provide you with what you want?  The only difference with your VAR _CountLastXDays would be that you use 'Table1'[New Column] rather than [userGuid].

 

Let me know if this is kind of what you're looking for?


Thanks
Theo

ksfx77's avatar
ksfx77
Icon for Helper I rankHelper I
4 years ago

Yes of course! Thanks!