Last None Blank in a row

[Anonymous]

I am currently trying to take a list of products from a bill of materials (BOM) which I have separated out manually and would now like to add a new column which displays the bottom level material for each product. Is there a way to iterate over each column in a row and then pull the value out?

For Example, the 'Bottom Level' column in the table below is what I would like to add in, the main issue appears to be how some things drop out earlier than others and I have no idea how to fix this.

Products	Sub Level 1	Sub Level 2	Sub Level 3	Bottom Level
Product A	Component 1	Component 2	Component 3	Component 3
Product B	Component 1			Component 1
Product C	Component 1	Component 2		Component 2

Many thanks in advance to anyone that can help

If there is any other information you think I have missed please let me know

[amitchandak]

@Anonymous , Try a new column like

coalesce([Sub Level 3],[Sub Level 2],[Sub Level 1])

[Anonymous]

I tried using Coalesce however it doesnt seem to accept column headers as inputs.

[Anonymous]

Of course, COALESCE DOES accept column headers as inputs IF you're in a row context. Here's the syntax and semantics:

https://dax.guide/coalesce/

[Anonymous]

Does this also work if each column sits in a different table?

i.e. In my model, sub level one is in a different table to sub level two as this was the only way to extract the data