Reply
Frequent Visitor
Posts: 14
Registered: ‎02-14-2017
Accepted Solution

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

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 

 


Accepted Solutions
Highlighted
Frequent Visitor
Posts: 14
Registered: ‎02-14-2017

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

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 

View solution in original post


All Replies
Moderator
Posts: 6,264
Registered: ‎03-06-2016

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

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 

Highlighted
Frequent Visitor
Posts: 14
Registered: ‎02-14-2017

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

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 

Moderator
Posts: 6,264
Registered: ‎03-06-2016

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

Hi @iokoli,

 

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

 

Best Regards,
Qiuyun Yu