Forum Discussion
Matrix with data from two related tables
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?
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:
- fix your source data or fix through a transformation in Power Query or
- merge the data in Power Query using fuzzy merge, then bring that single table into DAX.
1 Reply
- edhans
Community Champion
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:
- fix your source data or fix through a transformation in Power Query or
- merge the data in Power Query using fuzzy merge, then bring that single table into DAX.