Forum Discussion
Calendarauto
Hi there, Is there any other codes that i can use instead of calendarauto. I usually go for calendarauto to make a date table to connect with my data to create progress or plan by week report. The ...
Anonymous
you can define the range for a date table like so.
Dates = CALENDAR ( DATE ( 2018, 1, 1 ), DATE ( 2020, 12, 31 ) )
Anonymous , refer if these calendar's can help
1.Creating Financial Calendar - Decoding Date and Calendar 1-5 - Power BI Turning 5 Celebration Series
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
2.Any Weekday Week - Decoding Date and Calendar 2-5 - Power BI Turning 5 Celebration Series
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
You can start calendar like
calendar(Min(Table[Date]), Today())
calendar(date(1990,1,1), Today())
calendar(date(1990,1,1), date(2025,12,31))