Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
In my report i have two lists.
First list "A" has a column called "ID" which is multiple choice column
and Second List "B" which has column "ID" and "Title".
As i want to dispaly "Title" in my table i created a column which fetches data using lookup formula.
All goes well when IDs are not multiple.
When Multiple id are present in Second List "B", the report shows Blank values only.
It does not fetches any data.
Eg: If my list "B" has data as "1,2,3" i want the table to show titles from list "B" which corresponds to these IDs in the same row.
How can i achieve this? Please suggest some ideas.
Hi @abd3127 ,
The function LOOKUPVALUE() can only return the single data ranther multiple data, in your scenario, you can use the filter directly.
Best Regards,
Teige
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |