Forum Discussion
Calendar
How do I create a calendar with the start of the month different from a calendar month and the end of the month different from a calendar month? January would start from 3-30.
Hi Vindy ,
Do you mean the calendar with fiscal years?
Here are some links for your reference which introduces creating custom fiscal calendar table:
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-2-fiscal-columns
https://community.powerbi.com/t5/Desktop/Custom-Fiscal-Year-Calendar/td-p/85228
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Maintain an external calendar table, for example an Excel file on a sharepoint, or a table in SQL server, and then consume that table in Power BI.
lbendlin How do I keep a master file-calendar in excel but allow users to view in power BI in addition to trigger an outlook box email once they click on a certain date to request time off with a standard subject and screenshot paste to the body of the email? ? ?
Anonymous please create a new post for that question.
Hi Vindy ,
Do you mean the calendar with fiscal years?
Here are some links for your reference which introduces creating custom fiscal calendar table:
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-2-fiscal-columns
https://community.powerbi.com/t5/Desktop/Custom-Fiscal-Year-Calendar/td-p/85228
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
