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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors