Fiscal Year and Users Select the Fiscal Year

[bdehning]

I have read a lot and know how to create a Fiscal Year table for a predetermined month.

How do I create a fiscal table that allows users of the report to select a company that may have a Fiscal Year that could begin in any month of the year?   

Ultimately, I need a Line and Stacked Column chart to show the Fiscal Year and Months for the selection period and corresponding sales or unit counts.

[amitchandak]

@bdehning , In case you have different date for different companies

Microsoft Fabric and Power BI - Time Intelligence with Multi-Company Calendar/Date table. How to work with date table having multiple calendars in one table- https://www.youtube.com/watch?v=rIYc4IK-1ZY&list=PLPaNVDMhUXGYU97pdqwoaociLdwyDRn39&index=31

if you need

simple financial calendar

Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...
https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5e...
https://amitchandak.medium.com/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1

[bdehning]

I already have columns which have start and end dates for each company, can't I use that as a starting place to get counts per month for each company and show it by their starting month?