Output another value

[dreyes6]

Hello, can you please help me with this to have another calculated column?

SO this is the data

ID	Name	IMAGE	Price
1	A	BIKE
1	A	GOAT
1	A	BIKE	7750
2	B	TAXI
2	B	TAXI	150
3	C	Notes
3	C	Notes
3	C	Cycle	800
3	C	Cycle

And should add another calculated column to sow output or IMG column

ID	Name	IMAGE	Price	IMG OUTPUT
1	A	BIKE
1	A	GOAT
1	A	BIKE	7750	BIKE
2	B	TAXI
2	B	TAXI	150	TAXI
3	C	Notes
3	C	Notes
3	C	Cycle	800	Cycle
3	C	Cycle

Thanks!

[amitchandak · Accepted solution]

@dreyes6 , a new column

IMG = if(isblank(Table[Price]), blank(), [IMG])