The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)
)
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
30 | |
14 | |
12 | |
12 | |
7 |