Forum Discussion

ihartdata's avatar
ihartdata
Microsoft Employee
7 years ago
Solved

Calculated Column with Nested IF Statement, Use Contains, Search, Find??

I am trying to create a calculated column for a new triage status. So Far I have the following DAX, which covers bullets 1, 2 & 3 but I'm having a difficult time with the 4th and 5th bullets.  I just...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    ihartdata 
    I think this may assist.
    First custom column

    Semester Planning =
    LOOKUPVALUE (
    'Release Lookup'[Semester Planning],
    'Release Lookup'[ReleaseTime], Features[ReleaseTime]
    )

    Second custom column

    ReviewStatus =
IF (
    Features[FeatureStatus] <> "Rejected"
        && Features[FeatureStatus] <> "Rejected - Workaround Available"
        && Features[FeatureStatus] <> "Generally Available"
        && Features[FeatureStatus] <> "Public Preview"
        && Features[FeatureStatus] <> "Private Preview"
        && Features[Semester Planning] <> "No Plan",
    "Not Planned",
    "Planned"
)

    Thanks
    A

ihartdata's avatar
ihartdata
Microsoft Employee
7 years ago

Hi, 

 

Sorry, let me simplify my inquiry.

 

using the example pbix file, I'm trying to create a calculated column.  Where IF the column FeatureStatus in the Features table is anything other than Rejected, Rejected – Workaround Available, Generally Available, Public Preview, Private Preview AND the column Semester Planning in the Release Lookup table IS "No Plan" then it should be Not Planned, otherwise Planned. 

 

Does that make sense Anonymous ? 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

ihartdata 
I think this may assist.
First custom column

Semester Planning =
LOOKUPVALUE (
'Release Lookup'[Semester Planning],
'Release Lookup'[ReleaseTime], Features[ReleaseTime]
)

Second custom column

ReviewStatus =
IF (
    Features[FeatureStatus] <> "Rejected"
        && Features[FeatureStatus] <> "Rejected - Workaround Available"
        && Features[FeatureStatus] <> "Generally Available"
        && Features[FeatureStatus] <> "Public Preview"
        && Features[FeatureStatus] <> "Private Preview"
        && Features[Semester Planning] <> "No Plan",
    "Not Planned",
    "Planned"
)

Thanks
A