Forum Discussion

mmoroni's avatar
mmoroni
Helper I
5 years ago
Solved

Formula writing

I know sample data is best, and if need be, i can create something.  BUT - 
[Status]  [Address]
Active - 123 Main St
Inactive - 123 Main St
Inactive - 456 Main St

Looking for a formula that if the Address column of that row sees ANY line that has "active" in the status column, it reports back active; if not, it can state "inactive.

So, a new column would show
Active

Active

Inactive

Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    Try this:

     

    IsActive =
IF (
    "Active"
        IN CALCULATETABLE (
            VALUES ( Table1[Status] ),
            ALLEXCEPT ( Table1, Table1[Address] )
        ),
    "Active",
    "Inactive"
)

2 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    5 years ago

    Try this:

     

    IsActive =
IF (
    "Active"
        IN CALCULATETABLE (
            VALUES ( Table1[Status] ),
            ALLEXCEPT ( Table1, Table1[Address] )
        ),
    "Active",
    "Inactive"
)
    • mmoroni's avatar
      mmoroni
      Helper I
      5 years ago

      This was exactly what I needed!  I love this community!  Thank you!