Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Distinct dates from specific date until today

I want to calculate the number of unique dates from a given date until today. Does anyone know how I can achieve this?
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Pragati11, I already have a calendar/date table. I want to see how many days an employee has worked, by checking the distinct dates that occur in the source file until today.

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

Not sure if your question was clear in your query.

Please add more details on it like sample data input file and expeted output.

 

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Let's say this is the data.

     

    NameDate
    X26-6-2021
    Y27-6-2021
    Z29-6-2021
    X20-7-2021
    Y23-7-2021
    Z24-7-2021

     

    I want to count the the number of unique dates for X, Y or Z from the first available date until today.

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      5 years ago

      Hi Anonymous ,

       

      Counting unique dates against a name is easy as shown below:

       

      As you haven't attached the expected output along with the input, I will ask again what do you mean by - from the first available date until today ?

       

      Thanks,

      Pragati

    • v-kkf-msft's avatar
      v-kkf-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Anonymous ,

       

      Try the following formula:

       

      Measure = 
COUNTROWS(
    DATESBETWEEN(
        'calendar'[Date],
        MIN('Table'[Date]),
        TODAY()
    )
)

       

      If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

      Best Regards,
      Winniz

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.