Printing -1 in a DAX formula

[Sadou]

Hello dears community,

Kindly, i need help. I have an issu with my DAX formula , i want print the case that the result is false.  Here is the formula : 

Delais livraison new = IF(DATEDIFF(DATA[datePriseCommande], TODAY(),DAY)<1000, DATEDIFF(DATA[datePriseCommande],TODAY(),DAY),-1)

power bi is not printing the number -1 that will be the case where the condition is false.  look forward for help
thanks in advance. 

Happy new year !

[Sadou]

Hi @tamerj1 
Thanks for responding me .
I am creating the new calculated colum in the DATA table but the -1 is not coming out . The result if true is OK but the result is false is not coming out.

while in excel the -1 is there ....

[Anonymous]

Hi @Sadou ,

First, please make sure if the field DATA[datePriseCommande]  have any dates for 1000 days ago exactly. And did you apply any filter on the table before you checked the value? 

Best Regards

[tamerj1]

@Sadou |
Can you filter one of the cases were the difference is more than 1000 but you still don't get the -1? That would be a difference of around 3 years.

[tamerj1]

Hi @Sadou 

It should work if you are creating the new calculated column in the DATA table.