Forum Discussion
Solved
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 n...
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.
edhans
Community Champion
Community ChampionFuzzy 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.