Forum Discussion
One-to-Many Relationship with Unique Values Not Working
So, I've two tables (Excel Files) named 'Item Master' and 'Milestones'. Item Master has roughly 15 columns with a column named "Part Number". Milestone also has a column named "Part Number". ...
Tried that. Column Quality & Distribution shows 1000 distinct, 1000 unique, 100% valid, 0% error, 0% Empty. Ofcourse, I've 100,000+ part numbers so it's not that useful.
OK try the DAX, it should be quite quick to do.
Additionally, when using profiling and quality, the default is to sample 1000 rows. The whole dataset can be sampled by clicking on 'column profiling based on top 1000 rows' at the bottom of the power query screen. The other option is shown '...based on entire dataset' . Warning : it may take a long time