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 everyone! I currently have two related tables merged utilizing the fuzzy merge and transformation table feature. I am trying to build out a matrix that pulls data from both related tables, but not all the data is coming through. It seems as though any data that ties back to the transformation table is not carried over to the matrix. Has anyone encountered a similar issue?
Solved! Go to Solution.
Fuzzy merge is part of Power Query and does not carry over into the data model as a relationship. You cannot relate tables in DAX with fuzzy merge. So if you have data that isn't an exact match, DAX won't relate it.
If you want it in the DAX data model either:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingFuzzy merge is part of Power Query and does not carry over into the data model as a relationship. You cannot relate tables in DAX with fuzzy merge. So if you have data that isn't an exact match, DAX won't relate it.
If you want it in the DAX data model either:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |