Forum Discussion

rainchong7401's avatar
rainchong7401
Helper III
3 years ago
Solved

Add Dynamic Year in Column Name

Hi Friends, Is it possible to add year in column name?  So it change dynamically based on the year selection. If I select 2021, prev year column show 2020,  If I select 2020, prev year column s...
Need Help
  • rainchong7401's avatar
    rainchong7401
    3 years ago

    Hi,
    It's possible to do it. 
    I've done it already.

    CURPREV_YEAR = 
VAR Sales = CALCULATE([TOTAL_QTY],DATETABLE[YEAR] = SELECTEDVALUE('YEAR'[YEAR]))
return 
IF(
    SELECTEDVALUE('YEAR'[YEAR]) IN {MAX(DATETABLE[YEAR]),MAX(DATETABLE[YEAR])-1},Sales,BLANK()
)
Analystmate's avatar
Analystmate
Helper II
3 years ago

As far as I know, Changing the field name dynamically feature is not available.

  • rainchong7401's avatar
    rainchong7401
    Helper III
    3 years ago

    Hi,
    It's possible to do it. 
    I've done it already.

    CURPREV_YEAR = 
VAR Sales = CALCULATE([TOTAL_QTY],DATETABLE[YEAR] = SELECTEDVALUE('YEAR'[YEAR]))
return 
IF(
    SELECTEDVALUE('YEAR'[YEAR]) IN {MAX(DATETABLE[YEAR]),MAX(DATETABLE[YEAR])-1},Sales,BLANK()
)