I am attempting to build a report from our Sales List in SP Online. One of the columns ("Bid To") is a multi-select lookup column in which we select all of the clients the project bid was snt to. The number of selections range from 1 to 5 or 6.
When I query the list, the "Bid To" column is brought in as a Table. There are a couple of other single-select look up columns in the list that were brought is as either a List or as a Record. These were simple enought to expand, however I am stuck on the extracting the LookUp Value(s) from the table.
I have been digging through the forums, as well as any video tutorials i can find, but have not found any solutions. I am currently trying to create a custom column and leverage one of the Table, Record, or List Functions but as I am new to Power Bi and M, this is a bit of struggle.
The ultimate goal is to be able to report the total amount (both currency and quantity) of bids that were sent to each of the clients.
I would greatly appreacite any help I can get.