Forum Discussion
nosirui54
4 years agoHelper I
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, Weekl...
- 4 years ago
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.
AlexisOlson
4 years agoSuper User
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/