Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Combining two formulas

Hello,   I am trying to figure out how to add a formula that will look at two coloums and will return one value based on the critera. I want it to return value "Yes" where the resource is pricing a...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    5 years ago

    The [TaskId] = "03" has to be type text. Try as:

    Column = 
IF(
    'Table'[Resource] = "Pricing" && VALUE('Table'[TaskId]) >= 90,
    "Yes",
    "No"
)

    or as a measure:

    Measure = 
IF(
    SELECTEDVALUE('Table'[Resource]) = "Pricing" && VALUE(SELECTEDVALUE('Table'[TaskId])) >= 90,
    "Yes",
    "No"
)

Shahfaisal's avatar
Shahfaisal
Solution Sage
5 years ago

Perhaps your taskId column is of type text? If so, change that to numeric type and try the formula again.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    The same error appears.

     

     

    • ChrisMendoza's avatar
      ChrisMendoza
      Resident Rockstar
      5 years ago

      The [TaskId] = "03" has to be type text. Try as:

      Column = 
IF(
    'Table'[Resource] = "Pricing" && VALUE('Table'[TaskId]) >= 90,
    "Yes",
    "No"
)

      or as a measure:

      Measure = 
IF(
    SELECTEDVALUE('Table'[Resource]) = "Pricing" && VALUE(SELECTEDVALUE('Table'[TaskId])) >= 90,
    "Yes",
    "No"
)