[Expression.Error] We cannot convert the value "Band 4" to type List. Relative Referencing

[iokoli]

Hi,

I am trying to create a custom column using relative row referencing in the Power BI query editor. However I keep getting the below error.

[Expression.Error] We cannot convert the value "" to type List. 

My Code is as follows:

if ([Agenda for Change Band]{[Index]} <> null and [Area of Work]{[Index]} = null)  or ([Agenda for Change Band]{[Index]} <> null and [Agenda for Change Band]{[Index] +1} <> null) then 1 else ([#"Area of Work - Tag"]{[Index] - 1} = 1 and [#"Area of Work - Tag"]{[Index]} = 0)*1

Does anyone know why I keep gettin that error? I have a suspicion it has do with the indexing.

Any help would be appreciated.

Thanks,

Ikenna 

[iokoli · Accepted solution]

Hi,

I have figured it out. I just needed to put the table name in front of the columns.

i.e. Table Name [Column Name]{index}

thanks for the help @v-qiuyu-msft

Kind regards,

Ikenna 

[v-qiuyu-msft]

Hi @iokoli,

Glad to hear the issue is resolved by yourself. I will mark your reply as an answer to close this thread. 

Best Regards,
Qiuyun Yu

[v-qiuyu-msft]

Hi @iokoli,

Can you share us the pbix file if possible? You can use some dummy data to recreate the issue and share the pbix file with us. 

Best Regards,
Qiuyun Yu