Get Last non empty column in hierarchy

[GURUPRASADB]

Hi,

I have hierarchy table but last values are spilt across many columns based on non empty column. I want to have one column to join Fact table based in code. 

Value column should have last value from last non empty column

Please help me in solving this issue.

Expected result

[Mariusz]

Hi @GURUPRASADB 

Check if your columns are BLANK() or "" COALESCE works with BLANK() if you have "" or " " it will not work, but you can use SWITCH instead.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[GURUPRASADB]

Hi, 

I see COALESCE is working for only one column, but I have 6 columns to check. 

I tried with Switch also it wont work for multiple columns

value = SWITCH(TRUE(),

('Fact'[GL Account.Level 10.Key (Not Compounded)])="",'Fact'[GL Account.Level 08.Key (Not Compounded)],

('Fact'[GL Account.Level 08.Key (Not Compounded)])="" || ISBLANK('Fact'[GL Account.Level 08.Key (Not Compounded)]),'Fact'[GL Account.Level 07.Key (Not Compounded)],

'Fact'[GL Account.Level 11.Key (Not Compounded)])