Create a dynamic row for years

Question

Hi,&nbsp;hope some one suport, I would like to have a dynamic row based on the years, which should change automatically over the years.Example:Row&nbsp; &nbsp; Forecast&nbsp; &nbsp; Year1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Actual&nbsp; &nbsp; &nbsp; &nbsp; 20212&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20203&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LY-1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20194&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LY-2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018&nbsp;for next year should be:Row&nbsp; &nbsp; Forecast&nbsp; &nbsp; Year1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Actual&nbsp; &nbsp; &nbsp; &nbsp; 20222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20213&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LY-1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20204&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LY-2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2019&nbsp;thanks,&nbsp;Sergi

anonymous · Accepted Answer

Hi&nbsp;Sergi&nbsp;,
&nbsp;
According to your description, it seems you want to display last 3 years based on current date.
If so, please enter a table firstly and then create a measure:

Measure = 
var _yearToday=YEAR(TODAY())
return
SWITCH(MAX('NewTable'[Forecast]),"Actual",_yearToday,"LY",_yearToday-1, "LY-1",_yearToday-2, "LY-2",_yearToday-3)
Output:

&nbsp;
Best Regards,Eyelyn QinIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Create a dynamic row for years

2 Replies

Related content

Calculate Year over Year comparison dynamically

Creating a dynamic slicer

Dynamic Fiscal Year Calculation

How to Create Dynamic Slicers switching between Fiscal year and Calencar Year

Dynamic Years