Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bdehning
Post Prodigy
Post Prodigy

Fiscal Year and Users Select the Fiscal Year

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.

2 REPLIES 2
amitchandak
Super User
Super User

@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

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?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors