what is the right way to name a field ?

[admin11]

Hi All

I have below expression :-

Sales_2020 = CALCULATE([SALES_], DATESYTD(DATEADD('Date'[Date],-1,YEAR)))

Since above expression in next year , the field will need to change to 2021.

May i know it is possible to make the tbale label for this field auto change to Sales 2021 , so that don;t need to maintian.

Paul

[Fowmy · Accepted solution]

@admin11 

The formula that you have created will work regardless of the year that you are in. It always calculates the previous year-to-date sales from the current year that is in the filter context. You should rename your measure as "Previous Year YTD Sales" for better clarity.

[admin11]

@Fowmy 

Thank you very much.