Convert Integer values into years in DAX (Tabular Model)

[Parihar1980]

Hello 

I want to convert my interger column values into years using DAX fuincation in my tabular model . Please help me to do this.

Date1                       Date2                       Diff (In Days)            Expected Output 

01-01-2017              01-01-2016              365                           1

01-01-2017              01-01-2014              1096                         3

01-01-2017              31-12-2010              1097                         3.1

[BhaveshPatel · Accepted solution]

@Parihar1980

You should create two calculated columns (YEAR) & second column with a SWITCH() function that corresponds to the Year such as if it is 2016, then 365 days etc..

Then simply divide the days column with a second column.

Thanks,

Bhavesh

[Parihar1980]

Thanks Bhavesh for your suggestion. I am also looking for Where condition in the DAX expression 

Select name , id from table where id=2  how to write it in DAX