Forum Discussion
DAX to compare rows combination
Hi Community, Following is a snippet of my sample dataset (that has data quality issues): I want to compare Apnt date rows and apnt type rows combination. If there is a match then on...
Anonymous thanks for replying, regarding this issue I have posted a new question with better dataset and samle pbi file. Please check: Compare row combinations - Microsoft Power BI Community
amitchandak
Super User
Super UserAnonymous , Is the above your data format, or you have put that into a matrix.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Create a table with distinct or delete duplicates in power query
example
New table = Distinct(Table)