If conditions gives error

[Anonymous]

HI ,

@jdbuchanan71

I get this error I also tried to put the VALUE function still i get the same error?

Any help?

with VALUE Function:

Thanks,

Tejaswi

[tarunsingla · Accepted solution]

For the formula in your first screenshot (the one without "Value" keywords), change the last "=" on line 4 to a comma and see if that helps.

As a rule of thumb, the data type of the right hand side expression of the comparison equation, should be same as that of the left hand side.

[SteveCampbell · Accepted solution]

First check the numeric column.

In your Fields list, select the column 'Driver Amount' in the 'Discount Driver' table. Go to the Modelling tab and change the data type to a number if it is not already.

Then, change your dax so the two date parts are like this :

 'Discount Driver'[Payment Date] < ( TODAY() - 5 ) 

Lastly, make sure all individual statements with && are wrapped in ( ). 

So:

(statement 1 = 0 ) && ( statement 2 = 0 ) 

etc

Appreciate your Kudos
Connect with me!

Stay up to date on  
Read my blogs on  

[Anonymous]

Thanks @tarunsingla and @SteveCampbell  for your reply!

@SteveCampbell  my Dat type is in Numeric ( decimal format) and it was a silly mistake which @tarunsingla  promted.

@tarunsingla  your solutiosn worked!

Thanks,

Tejaswi

[tarunsingla · Accepted solution]

For the formula in your first screenshot (the one without "Value" keywords), change the last "=" on line 4 to a comma and see if that helps.

As a rule of thumb, the data type of the right hand side expression of the comparison equation, should be same as that of the left hand side.