Function in the name of the measure

[bapt69]

Hey everyone,

I would like to put a function in the name of a measure.

I put it in the name of the title of the visual but it's not enough for the users lol.

"Adhésion n-1" would be "Adhésion 2022" when you choose "2023" and "Adhésion n" would be "Adhésion 2023" obviously.

I hope I'm clear enough...

Thank you all!

[Anonymous]

Hi @bapt69 ,

Please share some sample data so that we could test formula.

[bapt69]

Exemple :

Table with customers (with registration)

Customer_id	Etablissement	RegistrationDate
21365	Boulou	15/10/2022
21366	StJean	16/10/2023
21367	Boulou	19/10/2023

Table with Date

Date	Month	Year
15/10/2022	10	2022
16/10/2022	10	2022
17/10/2022	10	2022
...

Link between RegistrationDate and Date

I create a column chart with x-axis=Month and y-axis=distinct(customer_id) of this year and distinct(customer_id) of the last year

These 2 measures have a name and we can change it...but how can we use a variable in the name of the measures?

When I choose year=2023, I would like the name of the measures is "Adhésion 2023" (adhésion n=2) and "Adhésion 2022" (adhésion n-1=1).

[bapt69]

n is the year you choose in the slicer and n-1 is one year before the year you choose