Just wrote a dax formula with the help of internet, but is there a way i can show the data till Sep row only with ytd numbers ?
YTD Sales = if( HASONEVALUE(Dates[FY]), CALCULATE([Charged Hours], FILTER( ALL(Dates), Dates[FY]=VALUES(Dates[FY]) && Dates[Calendar Dates]<=MAX(Dates[Calendar Dates]) ) ), BLANK() )
Also, i want to compare fy19 and fy20 ytd numbers (FY20 & FY19 - jul, aug, sep total). How should i proceed to write the dax to achieve this ? I have attached a snapshot for your reference.