Forum Discussion

gianmarco's avatar
gianmarco
Helper IV
3 years ago
Solved

Calculated column

Hey there!

Got a question. Considering the following table:

CODEDESCVALUE
ADesc120
A

Desc2

50
AX100
BDesc110
BDesc230
BDesc360
CDesc1100
CX30
CDesc240
CDesc350

 

I need to create a Calculated Column based on the following condition:

If a certain code "contains" Desc X, then calculate the double of column value EXCEPT the X's values.

The result would be the following table:

CODEDESCVALUENEW COLUMN
ADesc12040
A

Desc2

50100
AX100null
BDesc110null
BDesc230null
BDesc360null
CDesc1100200
CX30null
CDesc24080
CDesc350100

 

Thanks for your support 🙂

gianmarco

 

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)

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super 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)