Forum Discussion
Creating relationships between two tables
Due to the fact that the query editor (M) is case sensitive, while DAX isn't, you can run into problems here if you have spelling differences who just rely in cases: Although you remove dups in the editor, your list will not be unique for the model.
Check out this method as a workaround: http://www.thebiccountant.com/2015/08/17/create-a-dimension-table-with-power-query-avoid-the-bug/
Due to the fact that the query editor (M) is case sensitive, while DAX isn't, you can run into problems here if you have spelling differences who just rely in cases: Although you remove dups in the editor, your list will not be unique for the model.
Check out this method as a workaround: http://www.thebiccountant.com/2015/08/17/create-a-dimension-table-with-power-query-avoid-the-bug/