Forum Discussion

Salauat's avatar
Salauat
Regular Visitor
5 years ago

New column calculated by grouping

Hello gents, I have a table, which contains few columns, which I use to drill through visualizations. I want to create a new calculated column, which will be looking into "A1" and "Status". Can yo...
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago
Flag =
IF(
    ISEMPTY(
        FILTER( INFO, INFO[A1] = EARLIER( INFO[A1] ) && INFO[Status] <> "Good" )
    ),
    "Good",
    "Not Good"
)