Show Annual Figure among YearMonth table

[KH_Mike]

Hello,

I want to create a table which contain "YearMonth", "YTD", "This Month Result" and "Annual Result". Since my data contain serval year, I am not sure how to write the DAX in order to achieve it. I only have one table contain all the data including "Date" field. For the YTD (Fiscal Year), I use the DAX like below. 

Calculate(Sum(Result),DATESYTD(Data[Date],"03/31"))

I don't have any ideas how to always show the YTD for Fiscal Year end amount those "Date". Anyone can help or give some hints .... Thank you.

Date	YTD (Fiscal Year)	This Month Result	Annual Result
2020-04	2	2	90
2020-05	5	3	90
2020-06	9	4	90
2020-07	14	5	90
2020-08	20	6	90
2020-09	27	7	90
2020-10	35	8	90
2020-11	44	9	90
2020-12	54	10	90
2021-01	65	11	90
2021-02	77	12	90
2021-03	90	13	90
2021-04	1	1	78
2021-05	3	2	78
2021-06	6	3	78
2021-07	10	4	78
2021-08	15	5	78
2021-09	21	6	78
2021-10	28	7	78
2021-11	36	8	78
2021-12	45	9	78
2022-01	55	10	78
2022-02	66	11	78
2022-03	78	12	78
2022-04	0	0	101
2022-05	1	1	101
2022-06	3	2	101
2022-07	7	4	101
2022-08	13	6	101
2022-09	21	8	101
2022-10	31	10	101
2022-11	43	12	101
2022-12	57	14	101
2023-01	73	16	101
2023-02	91	18	101
2023-03	101	20	101
2023-04	1	1	4
2023-05	2	1	4
2023-06	3	1	4
2023-07	4	1	4

[lbendlin]

Let the data model and the quick measures do the work for you.