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 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