Forum Discussion
Calendar Table
Hello Experts
Please how can i create the following fiscal Calendar Table that:
1. Starts from February 2019 - to date, (or From February 2019 - January 2021 fiscal year) and
2. Has Daily, Weekly, Monthly and Qualterly Calendar?
Hi nosirui54 ,
According to your description, here’s my solution.
1.Create a date table, which has the max and min time of your calendar.
2.Create a new table like this.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Here's a fairly comprehensive template you can take the pieces you need from:
https://www.sqlbi.com/articles/reference-date-table-in-dax-and-power-bi/Hi nosirui54 ,
According to your description, here’s my solution.
1.Create a date table, which has the max and min time of your calendar.
2.Create a new table like this.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Awesome. Thank you SO much for the solution its works. Please Is there a way I can twist the Measures to (May 2019 - April 2030). Assuming, I don’t have existing reference Data to use the Min/Max with?
I mean how can I avoid the Min/Max, supposing I don’t have exiting data yet, like I just want to create a Fiscal Calendar Table (May 2019 - April 2030) or from (May 2019 – April 2021).
