Distinct dates from specific date until today

Question

I want to calculate the number of unique dates from a given date until today. Does anyone know how I can achieve this?

pragati11 · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
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))
&nbsp;
You can check more details here:&nbsp;https://docs.microsoft.com/en-us/dax/calendar-function-dax
&nbsp;
Thanks,
Pragati

anonymous · Answer

Hi&nbsp;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 · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Not sure if your question was clear in your query.
Please add more details on it like sample data input file and expeted output.
&nbsp;
Thanks,
Pragati

anonymous · Answer

Let's say this is the data.&nbsp;NameDateX26-6-2021Y27-6-2021Z29-6-2021X20-7-2021Y23-7-2021Z24-7-2021&nbsp;I want to count the the number of unique dates for X, Y or Z from the first available date until today.

pragati11 · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Counting unique dates against a name is easy as shown below:

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

Forum Discussion

Distinct dates from specific date until today

7 Replies

Related content

Count Distinct by Date

Count distinct count of date rows based on specific row values

count distinct

Enter Specific Date

Specific matrix