Dax for total sum up to selected month for each fiscal year

[cv2qm]

Hello Community,

I am trying to get the total sales up to selected month for each fiscal year (6/30).
Calender date table is connected with date column in all tables. 

I tried below DAX, but seems it is not working as expected. It is not adding up July and August month when i select September.
Also i am looking for Total sales from selected month till end of each fiscal year.

Could anyone help me with both DAX queries. 
1. Pre sales = Total sales upto selected month till end of each fiscal year (6/30).

2. Post sales = Total sales from selected month till end of each fiscal year(6/30).

Pre sales = 
VAR maxmonth=MAXX(Allselected('Calender'), 'Calender'[FiscalYear-Month] ) 
VAR maxyear=MAXX(Allselected('Calender'), 'Calender'[FiscalYear] ) 
var Sum_value = GA[Cost]+GL[Sum]+GL&GA[Other Amount] 
return CALCULATE(Sum_value,FILTER(ALL('Calender'),Calender[FiscalYear]=maxyear && 'Calender'[FiscalYear-Month]<=maxmonth))

Thanks in advance

[colacan]

@cv2qm  Hi,

I recomment to make calendar table with  CALENDARAUTO(6) which calcualte all timeseries functions based on fiscal year of Jul~Jun.  then you amy use TOTALYTD([sales], <Date>, [filter1, filter2...])

Thanks,

Please mark this as solution if this helped you.