Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi @mruf,
Based on current description, I'm not clear about your requirement.
'Solutions' seem to be importing a 'list' table and doing an inner join or writing code in DAX.
What function are you looking for? After using the 'Solution' you mentioned, what is the result? What is "a list table"? Do you mean multiple tables or a table contains a list of values?
Can you create a Filter object which can handle importing a text file containing a list of values?
How does the Filter object work? Is the data source a text file?
can have a list of values pated into it, seperated by a commas or semicolons like BOBJ Web Intelligence or SAP BW.
Do you mean separate column by delimiter?
Would you please provide sample data and show us your expected output to better illustrate your scenario?
Regards,
Yuliana Gu
Hi Yuliana,
Hopefully this picture will explain this very common function in many BI Tools. For example, in Business Objects Webi, as long as you delimit by semicolon, you can paste up to 1000 values in a filter...
Thanks,
M Ruf
Rockwell Automation
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |