Forum Discussion

Amaoa83's avatar
Amaoa83
Regular Visitor
2 years ago
Solved

How to Evaluate Strings in a Column

Hello all, Just getting back to PBI after a 2-3yr hiatus. The interface and a lot has changed in PBI. Trying to generate and format cells for the table contents below. Step 1- Step 6 columns are the...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Amaoa83 ,

     

    Modify you calculated column and create below measure:

     

    Step1Value = 
IF (
    AND (
        Projects[Deadline] - 30 < TODAY(),
        Projects[Status] = "Step 1"
    ),
    Projects[Deadline] - 30,
    BLANK()
)

    Step1Color = 
IF (
    ISBLANK(MAX(Projects[Step1Value])),
    "Green",
    "Yellow"
)

     

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Amaoa83 ,

 

Modify you calculated column and create below measure:

 

Step1Value = 
IF (
    AND (
        Projects[Deadline] - 30 < TODAY(),
        Projects[Status] = "Step 1"
    ),
    Projects[Deadline] - 30,
    BLANK()
)

Step1Color = 
IF (
    ISBLANK(MAX(Projects[Step1Value])),
    "Green",
    "Yellow"
)

 

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.