Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
apenaranda
Post Patron
Post Patron

List of contacts without records in related table

How could I get the list of contacts that have not been visited?
Scheme, contacts table related to interactions table.
The interactions table are records with the contact code and interaction code, in this case I need to check which contacts do not have any record with interaction code = SEG_CLI
The result must be the list of all contacts without SEG_CLI

1 ACCEPTED SOLUTION

Utilice "Mostrar elementos sin datos"

lbendlin_0-1713806759098.png

View solution in original post

3 REPLIES 3
apenaranda
Post Patron
Post Patron

 

customer table

 

cliente id

cliente1

cliente2
cliente3

 

interaccion table

 

id interaccionid clienteinteracciondate
1cliente1visita01/01/2024
2cliente1visita01/02/2024
3cliente2visita01/01/2024
4cliente2instalacion02/02/2024

 

The two tables are related.
What I want to get is a list of clients who have not made any visits. The visits are registered in the interaction table, as long as there is only one visit it is fine, the issue is that there are none. The easiest thing would be to see the interaction table directly and get the list but you have to keep in mind that not all clients have records, if they do not have records it means that they have not visited either, it should also be in the list of clients without a visit.

Utilice "Mostrar elementos sin datos"

lbendlin_0-1713806759098.png

Syndicate_Admin
Administrator
Administrator

Para informar sobre cosas que no están allí, debe usar tablas desconectadas y/o combinaciones cruzadas

Proporcione datos de muestra que cubran su problema o pregunta por completo, en un formato utilizable (no como una captura de pantalla).

No incluya información confidencial ni nada que no esté relacionado con el problema o la pregunta.

Si no está seguro de cómo cargar datos, consulte https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Muestre el resultado esperado en función de los datos de muestra que proporcionó.

¿Quieres respuestas más rápidas? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.