Forum Discussion
thebigwhite
Helper II
6 years agoLoading a table based on Min / Max from another Table
Good morning, I would like to have some tips on this scenario: I need to load a calendar table based on a time range interval which is coresponding to the Max And Min Date of another table. ...
- 6 years ago
thebigwhite , Based on what I got
You can try like
Date =calendar(Min(Table[Date]),Max(Table[Date]))
or date =calendarauto()
You can use addcolumns on top of it add other calendar columns
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
Appreciate your Kudos.
amitchandak
Super User
6 years agothebigwhite , Based on what I got
You can try like
Date =calendar(Min(Table[Date]),Max(Table[Date]))
or date =calendarauto()
You can use addcolumns on top of it add other calendar columns
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
Appreciate your Kudos.