Forum Discussion
Solved
Lookup Field
Hello, I have a SharePoint lookup field that is not giving me the value in Power BI. Can you not use a lookup field in PowerBI?
Yes, you can do this with CONCATENATEX() in DAX. I have a video tutorial describing various techniques for this sort of thing here if it helps - this is using a file source, not a SP list, but shows how to create the dimension table, relate them, then concatenate values with a comma between.
Sorry about that, I updated with screenshots.