the calendar table does not work in DAX functions DATEADD, PARALLELPERIOD, SAMEPERIODLASTYEAR

[Anonymous]

Hi everyone!

I have some problems with calendar dates. I made a table  "calendar" by function "CALENDARAUTO"

But DAX functions do not work at all. It calculated the share of all year, did not react to function FILTER, ALLSELECTED. Please, help to solve the problem

and

[amitchandak]

@Anonymous , Avoid using date hierarchy. Especially for key column of the date table

Try filetr like

filter(allselected(Date), Date[Date] <=max(Date[Date]))