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.
Hai all, I have created a calendar table by using this Dax
Here I want to show the "This year" text in the year field
The requirement is I have a slicer like this it will show this text every year dynamically (ie. If the current year is 2022 = the YEAR Column should show " this year", if it is 2023 it should show "this year "), Down I am attaching the Dax whichever I used in power bi as the master calendar
Solved! Go to Solution.
Hi
Can not catch you almost, I understand you want to replace the number of current year by text "this year".
If so, just need creat a new column of year
Year_2 = if([YEAR column] = YEAR(TODAY()),"This Year",[YEAR column])
then put Year_2 into slicer.
Hi
Can not catch you almost, I understand you want to replace the number of current year by text "this year".
If so, just need creat a new column of year
Year_2 = if([YEAR column] = YEAR(TODAY()),"This Year",[YEAR column])
then put Year_2 into slicer.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |