YTD Fiscal year starting July

[Easley06]

Hi, 

would like to ask on how to compute Fiscal YTD staring July - June

sample :

July 2022 - June 2023 

Thanks.

[wynhopkins]

You need a Calendar Table containing Fiscal Year and Fiscal Month Number and Month Name, then you need to use SortBy Column to make your months display July to June. Then your measure is Cost Fiscal YTD = TotalYTD( [Cost Measure], "30/06" ) If you're not familiar with Calendar table or need to download one then check out my video https://youtu.be/LfKm3ATibpE and download a Power Query Calendar table here https://accessanalytic.com.au/free-excel-stuff/free-excel-templates/