Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HI ,
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
Solved! Go to 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.
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
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
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
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |