Date slicer - Date difference in days

[PowerBITesting]

Title =

var Lable= "Avg sales per day "

var DateRangeYear =CALCULATE(DATEDIFF(Min(activitypointers[createdon]),MAX(activitypointers[createdon]),YEAR))

var DateRangeMonth =CALCULATE(DATEDIFF(Min(activitypointers[createdon]),MAX(activitypointers[createdon]),MONTH))

var DateRangeDate =CALCULATE(DATEDIFF(Min(activitypointers[createdon]),MAX(activitypointers[createdon]),DAY))

Var years=" Years"

Var Months=" Months"

Var Days=" Days"

return

if(DateRangeYear<>0,Lable & DateRangeYear & years,if(DateRangeMonth<>0,Lable & DateRangeMonth & Months,Lable & DateRangeDate & Days))

Date range date comes always zero - I am not able to get Date difference by Days. 

Month and year is working . 

[v-lili6-msft]

hi @PowerBITesting 

I have tested on my side, this formula works well

could you please share your sample pbix file for us have a test, there should be something wrong in other.

Regards,

Lin

[amitchandak]

@PowerBITesting , this should have given you

CALCULATE(DATEDIFF(Min(activitypointers[createdon]),MAX(activitypointers[createdon]),DAY))

Check the datatype too

Can you share sample data and sample output in table format?

[Greg_Deckler]

@PowerBITesting - That's very odd, can you share the PBIX?