Show year with apostrophe and last 2 numbers

[asodie]

Hi PBI Friends,

I have a bar chart that has year on the x-axis. Right now it shows 2014, 2015, 2016, etc. I want it to show '14, '15, '16, etc. instead. How can I do this with the apostrophe? Getting the numbers is easy (just subtract 2000) but I'm not sure how to add an apostrophe in a DAX statement. 

Thanks!

[ThxAlot]

A generic formular applicable to year 1998 or 3012

= "'" & MOD([Year],100)

[Greg_Deckler · Accepted solution]

@asodie Well, you could add a column that would be something like:

"'" & ( [Year] - 2000 )