i need t
1 Topic
Last Year dynamically calculated
Hi there, I'm facing with the following problem. I need to create an Last Year measure. then I created a calculated group like this: v_dim_time and v_fact_sales are related to 1:n var DayToCompare = today() var DateLastYear = EDATE(DayToCompare;-12) return calculate( SELECTEDMEASURE (); year(v_DIM_TIME[CALENDAR_DATE_SQL]) = Year(DateLastYear); v_DIM_TIME[CALENDAR_DATE_SQL] <= dateLastYear ) My problem is how can I to made the formula dynamical, saying for example that ytd will be evaluated at today - 365 if no other selection are made by time slicer otherview keeping the value selected ? Thank you in advanceSolved2.9KViews0likes2Comments