Forum Discussion
Custom Column Lookup Help
Hi all, I'm currently following this guide (https://community.powerbi.com/t5/Desktop/How-to-lookup-values-in-another-table-in-the-Query-Editor/td-p/529238) to create a custom column that functio...
Couldn't fix this in the end, had to use a lookup for a custom column outside of query editor instead.
We can't access the source data (that's by design, we don't have access to local files on your system), however, messing around with the data and trying out the M, it looks like the error is
"There weren't enough elements in the enumeration to complete the operation." or to translate, we can't find this value in the other file.
This will be for 2 reasons, either the value can't be found because there are differences in case (all the TaskType values are Upper Case) or it just doesn't exist in the other table.