topic Re: Printing -1 in a DAX formula in DAX Commands and Tips

Printing -1 in a DAX formula

Sadou — Fri, 30 Dec 2022 16:19:20 GMT

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 !

Re: Printing -1 in a DAX formula

tamerj1 — Fri, 30 Dec 2022 16:37:52 GMT

Hi Sadou

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

Re: Printing -1 in a DAX formula

Sadou — Fri, 30 Dec 2022 16:45:25 GMT

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 ....

Re: Printing -1 in a DAX formula

tamerj1 — Fri, 30 Dec 2022 16:48:48 GMT

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.

Re: Printing -1 in a DAX formula

Anonymous — Tue, 03 Jan 2023 07:20:08 GMT

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