Frequent Visitor
Posts: 9
Registered: ‎03-17-2017

change data type from whole number to year "yyyy"

Hello everyone


New to DAX and PowerBI, I am already having issues to convert data stored as whole number to year format, and then apply sameperiodlastyear.


The data 2015 stored as whole number, when data changed to date, becomes something weird like November 15, 2050. I want it to be stored as date in "yyyy" format, so the next formula can recognize this column as date to apply YOY.