merging of multiple columns with null value

[sanjanarama]

ID	hierachy	name	name1	name2	name3	final name
100	Global	a				a
101	Global	e	b			b
102	intermediate	f	g	c		c
103	country	h	i	j	d	d

I have data as above , and i wanted to build a custom column - final name, which is result of columns (name, name1, name2, name3).
seeing data from right to left, we need to pick the value of the column has the data encountered first. how can we achive this?

[amitchandak · Accepted solution]

@sanjanarama , In dax a new column

final name = coalesce([Name3],[Name2],[name1],[Name1])