Forum Discussion
Creating a calendar table.
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.
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.
3 Replies
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])) )
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.
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?
