Forum Discussion

selpaqm's avatar
selpaqm
Icon for Helper V rankHelper V
6 years ago

Find and expand value with another cell condition

Customer Week No Condition Week Result A 12 1 12 A 10 0 12 A 10 0 12 A 12 0 12 B 11 0 9 B 9 1 9 Hi all,   I want to create result column. it should...
Need Help
nandu_krishna's avatar
nandu_krishna
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

selpaqm 

 

Try this calculated column

 

Column =
VAR result =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Customer] = EARLIER ( 'Table'[Customer] )
                && 'Table'[Condition] = 1
        ),
        'Table'[Week No]
    )
RETURN
    result

 

 

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂