Convert Integer values into years in DAX (Tabular Model)

Question

Hello&nbsp;I want to convert my interger column values into years using DAX fuincation in my tabular model . Please help me to do this.&nbsp;Date1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Diff (In Days) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Expected Output&nbsp;01-01-2017 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01-01-2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;365 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 101-01-2017 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01-01-2014 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1096 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 301-01-2017 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;31-12-2010 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1097 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.1&nbsp;&nbsp;&nbsp;&nbsp;

bhaveshpatel · Accepted Answer

Parihar1980&nbsp;You should create two calculated columns (YEAR) &amp; second column with a SWITCH() function that corresponds to the Year such as if it is 2016, then 365 days etc..&nbsp;Then simply divide the days column with a second column.&nbsp;Thanks,Bhavesh

Forum Discussion

Convert Integer values into years in DAX (Tabular Model)

2 Replies

Related content

function to convert date to integer

How to convert time (HH:MM:SS) into integer?

Way to convert integer to datetime with DAX?

Convert Integer to Logical

Convert sting to integer Calculate