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.

Sethulakshmi's avatar
Sethulakshmi
Frequent Visitor
2 years ago

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?