Please let me know how to get current YTD and Previous YTD value for Multiple years
Now all the years are selected for this selection 2018 YTD and 2017 previous YTD should return.
If user selects only 2017 then Current YTD is 2017 Data value and Previous YTD will be 2016 Data value
For workbook you can use superstore file
Find my approach as reference below and stored in attached workbook version 10.5 located in the original thread,
and [Date]<today() then [Value] END
and [Date]<dateadd('year',-1,today()) then [Value] END
Hope it helps
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...