Forum Discussion
Anonymous
5 years agoNot applicable
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?
Pragati11
5 years agoSuper User
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