Forum Discussion
Create a column based on the value in same row or different row
I have below table, I want to create a new column that shows the default integration for the ID. i.e NewColumn below If the there is Default_Flag = 1 for then use the Integration value from that ...
Excel worksheet formula is enough
TheoC
Community Champion
Community ChampionHi Anonymous
Here is a quick calcualted column that will give you what you're after!
Calculated Column =
VAR _1 = MAXX ( FILTER ( 'Table' , 'Table'[ID] = EARLIER ('Table'[ID] ) && 'Table'[Default Flag] = "1" ) , 'Table'[Integration] )
RETURN
IF ( ISBLANK ( _1 ) , "No Default" , _1 )
Output is as per below:
Hope this helps!
Theo 🙂