DAX for comparing rows

[Anonymous]

Hi Community,

Following is a snippet of my sample dataset:

I want to compare Apnt date rows and apnt type rows combination. If there is a match then only distinct values are considered in the resultset.

So, with the right calculated column, the result would look like this:

Many thanks in advance!

[v-xiaotang]

Hi @Anonymous 

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.

Regards,

Community Support Team _Tang

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Have you solved this problem?

-

if not, you need to add an index column in your table firstly, or fill the table like bellow, 

then, here are 2 ways to remove duplicate rows,

(1) in PQ editor

(2) use DAX

TableTest2 = DISTINCT(TableTest1)

Note: the duplicate rows won't be removed unless you already have an existing way to order them such as an index column added in Power Query or a primary key from a db. 

Any question, please let me know. Looking forward to receiving your reply.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Power bi by default shows distinct values only. Values will not repeat, unless you have unique column

[Anonymous]

@amitchandak it is data quality issue with my dataset. Power BI doesnt show unique values in this case.

[amitchandak]

@Anonymous , Create a table with distinct or delete duplicates in power query

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

New table = Distinct(Table)