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...
Jos_Woolley's avatar
Jos_Woolley
Icon for Solution Sage rankSolution Sage
5 years ago

Hi,

 

NewColumn =
REPT (
    "Not ",
    CALCULATE (
        COUNTROWS ( 'Table' ),
        'Table'[Status] = "Not Good",
        'Table'[A1] = EARLIER ( 'Table'[A1] )
    ) > 0
) & "Good"

 

Regards