Forum Discussion
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 the resultset.
So, with the right calculated column, the result would look like this:
Many thanks in advance!
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.
5 Replies
Anonymous , Power bi by default shows distinct values only. Values will not repeat, unless you have unique column
amitchandak it is data quality issue with my dataset. Power BI doesnt show unique values in this case.
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)
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.
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
