Forum Discussion
Create Custom Calendar Table
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?
3 Replies
Hello Anonymous
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 Anonymous
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.
