Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX for comparing rows

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 ...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    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.

     

     

v-xiaotang's avatar
v-xiaotang
Community Support
5 years ago

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.