Forum Discussion

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?

Super User

5 years ago

Hi Anonymous ,

You can create a Calendar table in Power BI using your START DATE and END DATE. Something like below:

CALENDAR(DATE(2021, 1, 1), DATE(2021, 6, 1))

You can check more details here: https://docs.microsoft.com/en-us/dax/calendar-function-dax

Thanks,

Pragati

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
  Super 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
    Not applicable
    5 years ago
    Let's say this is the data.
    
    Name Date
    X 26-6-2021
    Y 27-6-2021
    Z 29-6-2021
    X 20-7-2021
    Y 23-7-2021
    Z 24-7-2021
    
    I want to count the the number of unique dates for X, Y or Z from the first available date until today.

Related content