This article did not help, it only gave me YTD or YOY which I know how to calculate. What I am looking for is a way to show the Full Prior year (all 12 Months), prior YTD (6 months) and current YTD (6 months). When I apply a filter to get the first 6 months I loose the prior year 12 month view. Any help would be ap[reciated.
I think you can put independent calculated field to get expected results?
[year 2015 act YTD]
if [Year]=2015 and [Date] <= dateadd('year',-1,today()) then [Actual] END
[year 2016 budget YTD]
if [Year]=2016 and [Date] <= today()then [Budget] END
[Var to Budget]
sum([year 2016 act])-sum([year 2016 budget YTD])
[Var to last year]
sum([year 2016 act])-sum([year 2015 act YTD])
YTD_calc_9.2.twbx 42.3 KB
This helped, thank you.
If you are O.K. could you mark my answer as "correct".