https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Year-Measure/m-p/3083869#M107647 <P>Jolly Day,<BR /><BR />I currently have my visual set to just give me year 2021. I am wanting it to automatically update going two years back so I need it set to year 2022 when we begin year 2024. Is there a way to accomplish this? I created a year column that just parsed the year from my date so we also have the full date to work with. Any help with this would be greatly appreciated!&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks in advance,<BR />Idon'tquitegotthepowerBI</P> Thu, 16 Feb 2023 18:56:07 GMT Anonymous 2023-02-16T18:56:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Year-Measure/m-p/3083869#M107647 <P>Jolly Day,<BR /><BR />I currently have my visual set to just give me year 2021. I am wanting it to automatically update going two years back so I need it set to year 2022 when we begin year 2024. Is there a way to accomplish this? I created a year column that just parsed the year from my date so we also have the full date to work with. Any help with this would be greatly appreciated!&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks in advance,<BR />Idon'tquitegotthepowerBI</P> Thu, 16 Feb 2023 18:56:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Year-Measure/m-p/3083869#M107647 Anonymous 2023-02-16T18:56:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Year-Measure/m-p/3084968#M107758 <P>You could create a measure like</P> <LI-CODE lang="markup">Year for TOPN = VAR ChosenYear = SELECTEDVALUE ( 'Date'[Year] ) RETURN IF ( ChosenYear &lt;= YEAR ( TODAY () ), ChosenYear ) </LI-CODE> <P>and then add a TOPN filter to your visual on the Year column using this measure as the value and set it to only show the top 2</P> Fri, 17 Feb 2023 12:22:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Year-Measure/m-p/3084968#M107758 johnt75 2023-02-17T12:22:15Z