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