Calendar

[Vindy]

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.

[v-stephen-msft · Accepted solution]

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.

[lbendlin]

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.

[bjaekel]

@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? ? ?

[lbendlin]

@bjaekel please create a new post for that question.