Can y straight column label display year dynamic ?

[admin11]

Hi All

My below expression the label will display Sales YTD , may i know how to make it dynamic display the year i selected , For example if i select year = 2018 , how to make it display 2018 , instead of alway display Sales YTD :-

Sales YTD =

var _max = date(year(today())-0,month(today()),day(today()))

return

TOTALYTD(('SALES'[SALES_]),dateadd('Date'[Date],-0,year),'Date'[Date]<=_max)

[dhooger]

I'm not finding a solution on this thread. I want to do something similar. Have a calculation group for the last four years and instead of the Name of the Calculation Items, I want to display the Max(Date[Year]). 

Thus the legend would update if someone changes the slicer. I have created a calculated column in the PBIX file but can't seem to figure out how to use that column in some Expression for the Name.

[sayaliredij · Accepted solution]

You can add something like below

Does it help?

Regards,

Sayali

[sayaliredij]

You can use a matrix instead of a table. 

In Rows you can mention "Customer Name"

In Columns "Year"

In Values = Sales amount

You will get the result you wanted

Regards,

Sayali 

If this post helps, then please consider Accept it as the solution to help others find it more quickly.

[admin11]

@sayaliredij 

Thank you for your sharing .

I just try it work fine .

But what i need is how to compute YTD vs LYTD. Now i am using stright table , it have no issue.

Paul Yeo

Paul Yeo

[sayaliredij]

Sorry I did not understand. 

I see you are getting the measure you require. Is there something missing? Could you please explain more?

Regards,

Sayali

[admin11]

@sayaliredij 

Sorry my explanation not so clear. 

notice that i only can achieve YTD vs LYTD sales by stright table. For Martix table i am not able to have YTD vs LYTD sales.

Below is my PBI file :-

https://www.dropbox.com/s/lx95lxy4q853wga/PBT_V2021_398_%20TI_SI_SAMPLE%20-%20Copy.pbix?dl=0

Paul