Forum Discussion

gianmarco's avatar
gianmarco
Icon for Helper IV rankHelper IV
3 years ago
Solved

Calculated column

Hey there! Got a question. Considering the following table: CODE DESC VALUE A Desc1 20 A Desc2 50 A X 100 B Desc1 10 B Desc2 30 B Desc3 60 C Desc1 100 C...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    gianmarco 

    pls try this

    Column = 
VAR _x=maxx(FILTER('Table (2)','Table (2)'[CODE]=EARLIER('Table (2)'[CODE])&&'Table (2)'[DESC]="X"),'Table (2)'[VALUE])
return if(ISBLANK(_x)||'Table (2)'[DESC]="X",blank(), 'Table (2)'[VALUE]*2)

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

gianmarco 

pls try this

Column = 
VAR _x=maxx(FILTER('Table (2)','Table (2)'[CODE]=EARLIER('Table (2)'[CODE])&&'Table (2)'[DESC]="X"),'Table (2)'[VALUE])
return if(ISBLANK(_x)||'Table (2)'[DESC]="X",blank(), 'Table (2)'[VALUE]*2)