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.
Please can someone help me with a calculated column in Dax, I want a numerical value representing the number of years prior to the current year based on a [Date] column. So the current year of 2022 = 0, 2021 = 1, 2020 = 2, 2019 = 3 and so on. I don't mind if it's negative values: 0, -1, -2 -3.
Thanks in advance!
Solved! Go to Solution.
@JemmaD Try:
Column =
VAR __CurrentYear = YEAR(TODAY())
RETURN
__CurrentYear - YEAR([Date])
@JemmaD Try:
Column =
VAR __CurrentYear = YEAR(TODAY())
RETURN
__CurrentYear - YEAR([Date])
Thanks Greg that was perfect
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |