Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI,
I need to create a calendar that starts on 1/3/2021 up until now or even a year out into the future. This date is the start of my week 1, not 1/1/2021.
I want this calendar to be daily rows and it would have the week number, year and month for all the rows of data.
How can I achieve this?
Hello @gmooney100
You can create a custom calendar as per your requirement.
Calendar Table = Calendar(Date(2021,01,03), Today())
This will give you calendar table from start to today as per your request.
If this post solve your problem, please accept it as solution so that others can reach quickly.
Hi Kishore,
Thank you for the response but I guess my problem is bigger than this.
Here are PDF for my calendar for 2021, 2022, and 2023. How can I attach the PDFs in this chat?
How can I create this calendar?
Hi @gmooney100
Here are some blogs for your reference. They are about creating calendar tables with DAX or Power Query in Power BI Desktop.
Power BI Calendar | How to Create Calendar Table in Power BI? (wallstreetmojo.com)
Creating Calendar Table in Power BI using DAX Functions - RADACAD
3 Ways To Create Date Table In Power BI DAX & Power Query | DataWolfs
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |