Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi everyone,
I would like to create a new calendar table using a date column in another table, which is table1[sending date].
And my new calendar table should start with the first day of the year of the earliest date of table1[sending date].
For example, table1[sending date] starts with 09/05/2021 and ends with 10/09/2022, so the new calendar table I will create should start with 01/01/2021 and end with 31/12/2022.
Could you please help me with this?
Thank you very much in advance!!
Solved! Go to Solution.
Hi,
CALENDAR(
DATE(YEAR(MIN(Table1[sending date])), 1, 1),
DATE(YEAR(MAX(Table1[sending date])), 12, 31)
)
It worked, thank you so much!!
Hi,
CALENDAR(
DATE(YEAR(MIN(Table1[sending date])), 1, 1),
DATE(YEAR(MAX(Table1[sending date])), 12, 31)
)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 9 | |
| 8 | |
| 6 | |
| 6 |
| User | Count |
|---|---|
| 20 | |
| 20 | |
| 17 | |
| 14 | |
| 14 |