topic Re: remove duplicates of date for same name but keep for different name in DAX Commands and Tips

remove duplicates of date for same name but keep for different name

Anonymous — Tue, 13 Sep 2022 21:21:39 GMT

hello guys i have a table where

name	Date	Active
A	8/1/2022	Yes
A	8/2/2022	Yes
A	8/3/2022	Yes
A	8/4/2022	Yes
A	8/5/2022	Yes
A	8/6/2022	Yes
A	8/7/2022	Yes
A	8/8/2022	Yes
A	8/9/2022	Yes
A	8/10/2022	Yes
A	8/11/2022	Yes
A	8/12/2022	Yes
B	8/1/2022	Yes
B	8/2/2022	Yes
B	8/3/2022	Yes
B	8/4/2022	Yes
B	8/5/2022	Yes
B	8/6/2022	Yes
B	8/7/2022	Yes
B	8/8/2022	Yes
B	8/9/2022	Yes
B	8/10/2022	No
B	8/11/2022	No
B	8/12/2022	No
B	8/10/2022	Yes
B	8/11/2022	Yes
B	8/12/2022	Yes
B	8/10/2022	Yes
B	8/11/2022	Yes
B	8/12/2022	Yes

so i want to remove the duplicates of dates for B on 8/10/2022 , 8/11/2022 and 8/12/2022 to keep the "No" and remove the "yes" but i want to kep the dates for A

this is my desired result:

Name	Date	Active
A	8/1/2022	Yes
A	8/2/2022	Yes
A	8/3/2022	Yes
A	8/4/2022	Yes
A	8/5/2022	Yes
A	8/6/2022	Yes
A	8/7/2022	Yes
A	8/8/2022	Yes
A	8/9/2022	Yes
A	8/10/2022	Yes
A	8/11/2022	Yes
A	8/12/2022	Yes
B	8/1/2022	Yes
B	8/2/2022	Yes
B	8/3/2022	Yes
B	8/4/2022	Yes
B	8/5/2022	Yes
B	8/6/2022	Yes
B	8/7/2022	Yes
B	8/8/2022	Yes
B	8/9/2022	Yes
B	8/10/2022	No
B	8/11/2022	No
B	8/12/2022	No

Re: remove duplicates of date for same name but keep for different name

amitchandak — Wed, 14 Sep 2022 03:02:58 GMT

Anonymous , a new table

Summarize(Table, Table[Name], Table[Date], "Active", Min(Table[Active]))

Also in power query use group by with Min

refer the groupin part here https://amitchandak.medium.com/power-bi-power-query-vs-dax-append-and-summarize-data-233f173d0839

Re: remove duplicates of date for same name but keep for different name

v-yadongf-msft — Wed, 14 Sep 2022 06:43:35 GMT

Hi Anonymous ,

Please try following DAX to create a new table:

New Table = FILTER('Table','Table'[name] <> "B" || NOT('Table'[Date] in {"8/10/2022" ,"8/11/2022","8/12/2022"}) || 'Table'[Active] <> "Yes")

The result you want:

Best regards,

Yadong Fang

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

Re: remove duplicates of date for same name but keep for different name

Anonymous — Wed, 14 Sep 2022 18:57:13 GMT

Hello what if i have the percentage of different number? What if investor C is yes but percentage for 10/1/2022 is 0.15 then 10/15/2022 is 0.2 and i have duplicates of percentage for same date so in 10/1/2022 till 10/31/2022 i have both percentage number so i want to have 0.15 from 10/1/2022 till 10/14/2022 and 0.2 from 10/15/2022 till 10/31/2022 i cant use the max([percentage]) becauee it will just show me 0.2 and if i use min([percentage]) it will just show me 0.15 for all the dates so how can i summarize it?