Creating a calendar table.

[tonny_bwg]

Hi, Guru,

please help with this problem. I want to create an automated calendar table in which the last date is the max date between onboard date and leave date. how to create it？(see figure below)

thanks in advance.

[Sethulakshmi]

Is it feasible to generate a calendar table within Fabric notebooks? Which approach adheres better to standardized procedures: creating a table through Power BI or using the calendar function within DAX?

[v-zhangti · Accepted solution]

Hi, @tonny_bwg 

You can try the following methods.

Date = 
CALENDAR(MIN('Table'[Onboard date]),MAX('Table'[Leave Date]))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@tonny_bwg ,

Try like

Calendar( Min(Min(Table[Onboard Date]), Min (Table[Leave Date])) , Max(Max(Table[Onboard Date]), Max (Table[Leave Date])) )

or

Calendar( eomonth(Min(Min(Table[Onboard Date]), Min (Table[Leave Date])),-1) +1  , Max(Max(Table[Onboard Date]), Max (Table[Leave Date])) )