Need to check Parent or Not

[Anonymous]

Hi team,

I need to create a calculate column, to check wheather it is parent or not based on "Sno =0"

if sno =0 with respective Parent Id then "Yes" else "No"

Thanks in Advance,

[mahoneypat · Accepted solution]

You can try this column expression.

HasParent =
IF (
    CALCULATE (
        COUNTROWS ( Table ),
        ALLEXCEPT ( Table, Table[ParentID] ),
        Table[Sno] = 0
    ) > 0,
    "Yes",
    "No"
)

Pat

[Greg_Deckler]

@Anonymous Column = IF([Sno]=0,"Yes","No")   ?

[Anonymous]

NO.

1.Consider with Parent ID , Sno =0, then it is parent.

2. If Sno<>0 then it is not parent.