Forum Discussion

jak8282's avatar
jak8282
Helper III
3 years ago

Calculated column not working

Hi,   For some reason my calculated column is no working - all values are a decimal number.   DAX is  TestRange70to79.9 = IF( AND( [Supplier Percentage Conv] >= 'Time Penalty'[Left...
Need Help
Dhairya's avatar
Dhairya
Solution Supplier
3 years ago
TestRange70to79.9 = 
IF(
   [Supplier Percentage Conv] >= 'Time Penalty'[LeftValue] AND
   [Supplier Percentage Conv] <= 'Time Penalty'[right position],
    "Yes", 
    "No"
)

Please try this

 

  • jak8282's avatar
    jak8282
    Helper III
    3 years ago

    That doesnt work it comes back with the error

     

    The syntax for 'AND' is incorrect. (DAX(IF( [Supplier Percentage Conv] >= 'Time Penalty'[LeftValue] AND [Supplier Percentage Conv] <= 'Time Penalty'[right position], "Yes", "No"))).

     

    I have also tried 

    TestRange70to79.9 = 
IF(
   [Supplier Percentage Conv] >= 'Time Penalty'[LeftValue] &&
   [Supplier Percentage Conv] <= 'Time Penalty'[right position],
    "Yes", 
    "No"
)

    Which doesnt work either

    • Dhairya's avatar
      Dhairya
      Solution Supplier
      3 years ago

      Hey jak8282 
      Can you please share sample data and measures which are used for plotting so that I can try it on my machine?