Forum Discussion
Solved
Lookupvalue in calculated column power query not working
I am creating a calculated column using Lookupvalue to state what type action each row is. I am using the following in my power query: It is all working and I am getting the expected...
Hi All,
I found my problem.
A relationship between two unrelated tables had a filter going both ways rather than single. This was somehow filtering things incorrectly.
As soon as I changed it to single, the function started working.
Hi rlymer ,
Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!
Best Regards,
Community Support Team _ kalyj
Hi All,
I found my problem.
A relationship between two unrelated tables had a filter going both ways rather than single. This was somehow filtering things incorrectly.
As soon as I changed it to single, the function started working.