Can't find a way to do this!

[miguelPBI]

I need some help to create a new column...

I have a table with several columns (e1 to e12, text)

I need to create a new column with the value of the last non-empty column

What formula should I use to create the new column?

e1	e2	e3	e4	e5	e6	e7	e8	e9	e10	e11	e12	New column
03	2	9										9
5	1	003	1	0	5	2	02					02
1	0401	2	3	4								4

[ChrisMendoza · Accepted solution]

In Power Query, it looks like you can use:

List.Last(List.Select({[e1],[e2],[e3],[e4],[e5],[e6],[e7],[e8],[e9],[e10],[e11],[e12]}, each _ <> ""))

The pattern I found at https://stackoverflow.com/questions/31405094/how-can-i-perform-coalesce-in-power-query

[miguelPBI]

Thanks Chris, it works perfectly!