Forum Discussion

tonny_bwg's avatar
tonny_bwg
Helper I
4 years ago
Solved

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) ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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's avatar
amitchandak
Super User
4 years ago

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])) )