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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

ihartdata 
Again,
I am having trouble understanding your syntax.

Once you clarify what you need, we might assist.
CheerS!
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

    • vivran22's avatar
      vivran22
      Community Champion
      7 years ago

      ihartdata 

       

      Hi,

       

      Please see the pbix file here.

       

      Hope this should solve the purpose.

       

      Thanks,

      Vivek

       

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