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"
)

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"
)