How to custom Datetab if your financial year have 14 month start from Nov How to calculate YTD, MTD

[firstcha]

please help me i have to calculate YTD, MTD but my financial year start from Nov-Dec (have 14 month in 1 year), how should I write dax for custom datetable.

thankyou

Best Regard 

firstcha

[v-rzhou-msft · Accepted solution]

Hi @firstcha ,

As far as I know, fiscal year should also be 12 months in each year. If based on your logic, FY2022 should be 2022/11 to 2023/12, then FY2023 couldn't start from 2023/11. 

You may refer to below post with similar issue like yours to learn more details about how to create fiscal years.

For reference:

https://community.powerbi.com/t5/Desktop/Fiscal-Year-Calculated-Columns/m-p/149604

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[firstcha]

hi @v-rzhou-msft  ,thankyou very much for your help

Best Regard
firstcha 

[daXtreme]

www.daxpatterns.com