Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I've used CALENDARAUTO(3) to create my calendar table but it starts at this fiscal year. How would I compare YTD performance to the prior year if my calendar table doesn't contain those dates?
Solved! Go to Solution.
Hi @joeort,
CALENDARAUTO() automatically creates a table with one column named "date". The range of dates is calculated automatically based on data in the model. For having years included in your date-table, which are not part of your data model you cannot use CALCULATEAUTO(). Try something like the following:
YourCalendarTable =
CALENDAR (
DATE ( YEAR ( MIN ( YourTable[DateColumn] ) -1 ); 1; 1 );
DATE ( YEAR ( MAX ( YourTable[DateColumn] ) ); 12; 31 )
)
Regards,
Lars
Hi @joeort,
CALENDARAUTO() automatically creates a table with one column named "date". The range of dates is calculated automatically based on data in the model. For having years included in your date-table, which are not part of your data model you cannot use CALCULATEAUTO(). Try something like the following:
YourCalendarTable =
CALENDAR (
DATE ( YEAR ( MIN ( YourTable[DateColumn] ) -1 ); 1; 1 );
DATE ( YEAR ( MAX ( YourTable[DateColumn] ) ); 12; 31 )
)
Regards,
Lars
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |