Master Power BI: Create Your Own Easy Fiscal Year Calendar 

If your fiscal year does not start on January and you would like to create your fiscal quarters, months, weeks according to your fiscal start month, please check out this guide here, it details the steps to create a fiscal calendar, regardless of your fiscal start month or week start day: buymeacoffee.com/missmicrosoft/e/258842

Great video with easy to follow instructions. Well done.

Thank you so much . This has saved my life

My main table didnt change dates as per the calendar table.

thank you very much for this really simple to understand and follow guide!

How do you add Fiscal year? I copied fiscal month formula and changed it to year but it's just pulling the current year. My fiscal year starts in Feb. Fiscal quarter is using -1 as the parameter and working fine, this was easy to follow

Brilliant

you rock ! crystal claer ! One question : I added the "fiscal year" following the same methodology but it's not recognized as year per powerbi, any tips ?

Thank you so much!

Very nice South African accent.

Thank you

Hi could you help me if i want to add column to identified which for Fiscal Year by month ? such as when April 2024 is FY25

What if financial year starts from 17th of july every year?

This is helpful, but I am new at this. Our FY starts April, How could I get Fiscal Quarter to say Q1-23 and have Jan 24 be in FY 2023 for Q4-23, then how do I use this with a report?

Ma'am, I have 3 tables in 3 different work sheets of the same work book. One is Main Data Table, 2nd is Block Names with code against each name, and the 3rd is Craft Names with codes against each name of the Craft. The problem is that I have to add two columns (Block & Craft) to the Main Data Table on the basis of the codes which are embedded in one of the columns (Registration Number) of Main Data Table . In Registration Number Column, the craft and block are embedded in the form of codes which are separated by delimiter dash (-) Please write a dynamic power query code. I will provide the list of Blocks & Crafts The Blocks will remain only 8 in number and wouldn't change but the list of Crafts may change/increase in future. Therefore, if there is any addition in the Craft that should be automatically added. Example of Registration Number Column: ADHS-SFK-CPWS-01 ADHS-SHL-KS-01 ADHS-RAM-CPT-106 ADHS-SR-CRL-015 ADHS-PTH-KTS-066 ADHS-GDB-TAP-217 ADHS-SKDLA-SZ-07 ADHS-SKDLB-STP-044 In the above Registration Number column, the coding for Crafts is as undder: CPWS= Copperware Sakhta KS= Kani Shawl CPT= Carpet CRL= Crewel KTS= Katas TAP= Tapestry SZ= Sozni STP= Stapple and the coding for Blocks are: SFK= Safakadal SHL= Shalimar RAM= Rambagh SR= Soura PTH= Panthachowk GDB= Gadoodbagh SKDLA= Saidakadal-A SKDLB= Safakadal-B