Forum Discussion
Create new Reference table for Financial Year based on date range
dd88 , Do want to create overlapping years?
You can FY Column in same table as Calendar year table
1.Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5ee47de6a208
https://amitchandak.medium.com/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1
DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
https://www.youtube.com/watch?v=IsfCMzjKTQ0&t=145s
Power BI Date Table: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=18180s
Join between would be tricky and in DAX you have bring column by column. You can add columns based on the logic given in blog or attcahed file.
awesome I will have a look. many thanks amitchandak
Hi dd88 ,
amitchandak's reply was great.
Pls has your problem been solved? If so, accept his reply as a solution. This will make it easier for the future people to find the answer quickly.
If not, please provide a more detailed description, preferably some virtual sample data, and the expected results.
Best Regards,
Stephen Tao