i have Date field = 12-01-2023 and Year_month = jan-2023. i have period filter have ytd and rolling 12 months. Based on the selction of filter my all visuals should interact. if i have selected ytd, all visuals should show ytd data.
for ytd i wrote like this
Load [Year-Month],
'YTD' as [Period]
resident test table
where Year([Year-Month])=2023;
but for rolling 12 months what to write i am confusing, Please help me