Forum Discussion
Solved
Fiscal Year Problem
Hello, I have a data table of companies having different fiscal year start and end dates. 1. Type 1: Fiscal Year Start Date- For FY2022, FY start date is April 2022, FY end date is March 2023...
this is 2 variant
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Hello Thanks for your reply, really appreciate it,
I wanted to ask how I can connect this with my subsidiaries using different fiscal years?
Could you please explain what you did here?
Sorry, I am a rookiethis is 2 variant
to know how to do this watch my video
https://1drv.ms/v/s!AiUZ0Ws7G26RjEUXYiylegdFSDIy?e=yI94p3
Fiscal = CALCULATE( SELECTEDMEASURE(), VAR FirstFiscalMonth = 4 VAR LastDay = MAX('Calendar'[Date]) VAR LastMonth = MONTH(LastDay) VAR LastYear = YEAR(LastDay) - IF(LastMonth < FirstFiscalMonth, 1) RETURN DATESBETWEEN ( 'Calendar'[Date], DATE(LastYear, FirstFiscalMonth, 1), LastDay ) )
