Hello
I am trying to work out a YTD for last year when my year runs July-June.
My YTD for July-June is as followed:
Value Sale YTD:=TOTALYTD(SUM(Total[Value Sales]),Dates[Time],Dates[Time],"30-06")
And this seems to give the figures I require
But when I try:
YTD Last Year:=TOTALYTD(sum(Total[Value Sales]),DATEADD(Dates[Time],-12,MONTH))
It calculates the YTD from last year but Jan-Dec, and not the July-June I require.
Any insight would be great
Thanks
I am trying to work out a YTD for last year when my year runs July-June.
My YTD for July-June is as followed:
Value Sale YTD:=TOTALYTD(SUM(Total[Value Sales]),Dates[Time],Dates[Time],"30-06")
And this seems to give the figures I require
But when I try:
YTD Last Year:=TOTALYTD(sum(Total[Value Sales]),DATEADD(Dates[Time],-12,MONTH))
It calculates the YTD from last year but Jan-Dec, and not the July-June I require.
Any insight would be great
Thanks