Forum Discussion

freemainia's avatar
freemainia
Helper I
3 years ago
Solved

Add column whose value depends on two other columns

I have a column called ID and another called Status.    I want to create a new column called NEW COL.   If Status = "Yes" for any of the rows with the same ID then the NEW COL = "Yes" for those r...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    freemainia 

    Give this a try.

    New Status = 
VAR _Yes = CALCULATE(COUNTROWS(VALUES('Table'[ID])),'Table'[Status]="Yes",ALLEXCEPT('Table','Table'[ID]))
VAR _Partial = CALCULATE(COUNTROWS(VALUES('Table'[ID])),'Table'[Status]="Partial",ALLEXCEPT('Table','Table'[ID]))
RETURN 
SWITCH(
    TRUE(),
    _Yes > 0, "Yes",
    _Partial > 0, "Partial",
    "No"
)
jdbuchanan71's avatar
jdbuchanan71
Super User
3 years ago

That is how you would do it as a calculated column.  You would just put that DAX in as the new column on the table.