Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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?
Solved! Go to Solution.
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 _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 _ kalyj
If 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).
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/
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
102 | |
68 | |
46 | |
37 | |
37 |