topic Re: How to custom Datetab if your financial year have 14 month start from Nov How to calculate YTD, MTD in DAX Commands and Tips

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

Anonymous — Thu, 17 Nov 2022 16:06:56 GMT

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

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

daXtreme — Thu, 17 Nov 2022 17:19:04 GMT

www.daxpatterns.com

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

Anonymous — Mon, 21 Nov 2022 09:26:18 GMT

Hi Anonymous ,

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.

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

Anonymous — Wed, 23 Nov 2022 07:57:47 GMT

hi Anonymous ,thankyou very much for your help

Best Regard
firstcha