Resolved: Question Regarding CALENDARAUTO and Multiple Date Columns
In our scenario where the dataset includes two different dates: one for customer birthdays and another for order dates. we using the CALENDARAUTO function in Power BI to create a date table. However, we want to ensure that the calendar automatically created by CALENDARAUTO only considers the order dates and not the customer birthday dates.
Is there a method or approach within Power BI or DAX to configure the CALENDARAUTO function to focus solely on the order dates column while excluding other date columns such as the customer birthdays?
Thank you for your guidance!
Is there a method or approach within Power BI or DAX to configure the CALENDARAUTO function to focus solely on the order dates column while excluding other date columns such as the customer birthdays?
Thank you for your guidance!
1 answers ( 1 marked as helpful)
In this case I would suggest you use CALENDAR(Min(OrderDates), Max(OrderDates)) this will create a range between all dates in Order Dates only.