Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Hi @bapt69 ,
Please share some sample data so that we could test formula.
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).
n is the year you choose in the slicer and n-1 is one year before the year you choose
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |