Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |