Need help to filter the records for the same name and different locations.

[Saichebrolu]

Hello community, Need help
   from below table need to filter the records for the same name and different locations. please help me thanks.

sample data:

Name	Location	Date
sai	hyd	7/10/2023
sai	Bangalore	7/5/2023
keerthi	hyd	7/1/2023
adi	hyd	7/2/2023
surekha	hyd	7/3/2023
suri	hyd	7/4/2023
suri	hyd	6/10/2023
charan	hyd	6/11/2023
charan	chennai	6/12/2023

Expected Output:
---------------

Name	Location	Date
sai	hyd	7/10/2023
sai	Bangalore	7/5/2023
charan	hyd	6/11/2023
charan	chennai	6/12/2023

[mcaraballo]

HI!

Using this sample data, I created the same table and then I just added this calculated column. 

Then, you just need to filter when column = 1, and you will get the output you need!

Hope this helps you!
Regards,
Mariano.

DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO!

[Semaj06]

Hi

Not sure to understand you at 100%. I made this. Hope it can help.

Filter the new column in 1

colonne =
IF (
Feuil1[Colonne] = 1,
1,
IF (
CALCULATE (
MAXX ( Feuil1, Feuil1[Date] ),
ALLEXCEPT ( Feuil1, Feuil1[Name], Feuil1[Location] )
) = Feuil1[Date],
1,
0
)
)

[olgad]

Dear @Saichebrolu, apologies, dont quite follow you. Do I understand you right, that you dont want suri hyd combination in your list?
if so, then create a concat column of name and location
and then this calc

Column = If(Calculate(Count('Table'[Concat]), ALLEXCEPT('Table','Table'[Concat]))=2,false,if( Calculate(Count('Table'[Name]), ALLEXCEPT('Table','Table'[Name]))=2, true, false))

[Saichebrolu]

@olgad 
Sorry for the inconviniance.Yeah it's almost working. but my requirment has got enhanced.
We need to filter the all duplicate names along with morethan one location.
Note: We can have duplicate locations with in a single name(if we have more than one locations)

data table:

Name	Location	Date
sai	hyd	7/10/2023
sai	Bangalore	7/5/2023
sai	hyd	7/11/2023
keerthi	hyd	7/1/2023
adi	hyd	7/2/2023
surekha	hyd	7/3/2023
suri	hyd	7/4/2023
suri	hyd	6/10/2023
charan	hyd	6/11/2023
charan	chennai	6/12/2023
charan	cennai	6/3/2023

Expected Output:

Name	Location	Date
sai	hyd	7/10/2023
sai	Bangalore	7/5/2023
sai	hyd	7/11/2023
charan	hyd	6/11/2023
charan	chennai	6/12/2023
charan	cennai	6/3/2023

[mcaraballo · Accepted solution]

Hi @Saichebrolu , I think that the solution I posted earlier works, including the new requirement.

Creating the same column:

column = countrows(filter(tabla,

Tabla[Name] = EARLIER(Tabla[Name]) &&

Tabla[Location] <> EARLIER(Tabla[Location])))

And then you have to filter when this column is not blank.

[Saichebrolu]

Hi @mcaraballo i got aa one more enhancement in the requirment. need help.
Conditions:

-------------------

1.Need to filter records for createdDate last 30 days.
&&
2.Name should have more than one location.
Note: 8/4/2023 is the current date.
Sample Data
---------------

Name	Location	Created Date
sai	hyd	8/4/2023
sai	Bangalore	7/6/2023
sai	hyd	7/11/2023
keerthi	hyd	7/1/2023
adi	hyd	7/2/2023
surekha	hyd	7/3/2023
suri	hyd	8/4/2023
suri	hyd	8/1/2023
charan	hyd	8/4/2023
charan	chennai	6/12/2023
charan	chennai	6/3/2023
Ravi	hyd	8/4/2023
Ravi	Bangalore	5/6/2023
Ravi	hyd	7/11/2023

Expected Output
-----------------------

sai	hyd	8/4/2023
sai	Bangalore	7/6/2023
sai	hyd	7/11/2023

[mcaraballo]

Hi @Saichebrolu ,

for some reason I was not able to make it work in the same column/table (I thought that with a littler change it was going to work). To ge the expected output I had to:

1st step: create a new table with the <= 30 days filter, based on the first table I told you in previous message.

2nd step: create this column:

Column2 = countrows(filter('table2', 'table2'[Name] = EARLIER('table2'[Name]) && 'table2'[Location] <> EARLIER('table2'[Location]) && 'table2'[column] >= 1 ))

then, filter when this "column2" is not blank.

I think this will work.

Regards,

Mariano.

PS: please, visit this idea and vote it if you like it ! Ability to show/hide any object based on a conditi... - Microsoft Fabric Community

DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO!

[mcaraballo]

Hi @Saichebrolu did it work ? 

Regards,

Mariano.

PS: please, visit this idea and vote it if you like it ! Ability to show/hide any object based on a conditi... - Microsoft Fabric Community

DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO!

[olgad]

Hi, create a calculated column to see the duplicates 

Column = Calculate(Count('Table'[Name]), ALLEXCEPT('Table','Table'[Name]))

Then filter the visual for the value of 2. 

[Saichebrolu]

@olgad

PREVIEW

Thanks for your reply but from above calculation i will get below output right.

Name= "suri" belongs to single location that is "hyd"
we should get duplicate names with different locations data.

Name	Location	Date
sai	hyd	7/10/2023
sai	Bangalore	7/5/2023
charan	hyd	6/11/2023
charan	chennai	6/12/2023
suri	hyd	7/4/2023
suri	hyd	6/10/2023