can we set column name in dax which is change in slicer selection

[Anonymous]

hi i have calculated  dax , where i want change column name in dax.

example: in slicer i select 2021-2022, column name should be change  current Year to  "2021-2022"

and if i select 2020-2021 and 2021-2022 , column name should be change  current Year to  "2021-2022" and Pre Year to 2020-2021

current Year =

CALCULATE(sum(Sales[F Net Value_CR]),FILTER(Master_Calendar,Master_Calendar[F Year]=year(TODAY()-365) ))

Pre Year = CALCULATE(sum(Sales[F Net Value_CR]),FILTER(Master_Calendar,Master_Calendar[F Year]=year(TODAY()-730)))

below is output

slicer is below.

[Anonymous]

Hi @Anonymous ,

Since there are serveral tables and many data, please share me with your pbix file after removing sensitive data to solve your issue more quickly.

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[amitchandak]

@Anonymous , refer if this blog from Parry can help

Show dynamic column name
https://perytus.com/2021/02/04/improve-ux-show-year-in-legend-when-using-time-intelligence-measures/

[Anonymous]

hey thanku😀, now your dax is working but i am facing one problem..value is showing same , total and BH & state wise wise value is showing same. please help

Sales New =

//get selected year, if no year is selected or more than one year is selected

//then get the most recent year from the table

VAR __selectedYear =

SELECTEDVALUE (

'Master_Calendar'[F Year],

YEAR ( TODAY() )

)

//get previous year by simply substracting one from the selected year

VAR __prevYear = __selectedYear - 1

RETURN

CALCULATE (

Sales[AAA],

//turn off the relationship between the date and fact table

CROSSFILTER ( 'Master_Calendar'[Date_N], Sales[CDate], NONE ),

KEEPFILTERS (

TREATAS (

{ __selectedYear, __prevYear },

//apply filter to the fact table on the selected and prev year

Sales[Year]

)

)

)

[Anonymous]

when i used you dax ,below error is showing.