Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello All!
I need your help about relationship from two table.
In this table I have a similar column called TEXT_KEY (it is a concatenate of string) and I would like to create a relationship from table 1 to get data from table 2.
Is possibile to use Fuzzy function to create only relashionship?
Is there a way to create a SQL "like" relationship?
Many Thanks!
Hello! You can find below a example of data
In a report I have a pareto with column WC and column VALUE from Table 1 and pareto with column CAUSES and column VALUE from tabel 1.
I would like when I click on pareto filter the table 2 based on column used in pareto.
If a I click on the first pareto, table 2 must to be filtered on colum WC, if I click on the second pareto, table 2 must be filtered on column CAUSES.
How can I do this type of automatic filter?
Many Thanks
Hi @danilomorganti ,
Would you pls provide the sample data with pareto inside?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Thank you for your answer!
What I want is, when I click on the chart of table 1 if in table 2 there are some corresponding it populates a table view.
Hi @danilomorganti ,
Can you make some screenshots as examples to make the requirement more clear?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
You can do a fuzzy merge in the query editor, but not on the DAX side. You could approximate it using FILTER and SEARCH, CONTAINS, LEFT, etc., if the two columns differ in a similar way.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |