The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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)
)