Forum Discussion
5-4-4 Fiscal Calendar
I am struggling with crating a fiscal calendar in Power BI. We follow a 5-4-4 week format, so for instance our 2015 fiscal year started Sunday, 12/28/2014. While I downloaded a template, there a...
v-huizhn-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
Based on the error message, you tried to create a relationship between two tables, one table is Fiscal Calendar table, what about another one?
Best Regards,
Angelia
v-huizhn-msft Anonymous
Thanks for the input. You two really exemplify the value of the PBI community!
I was able to make the connection through an Excel format.
With that said, I am still challenged with the custom fiscal calendar and how to have it work properly. Can you take a look at this post, and lend your thoughts?
https://community.powerbi.com/t5/Desktop/Date-Layout-amp-Fiscal-Calendar/td-p/226902
- v-huizhn-msft
Hi Anonymous,
I review the new post, Dale has post the detailed solution. Please follow it.
Best Regards,
Angelia