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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
mmoeller
Regular Visitor

Todos los valores distintos de la tabla1 Column1 para cada uno de los valores distintos de la columna 2 de la tabla2

Hola

Tengo dos columnas en dos tablas diferentes y quiero crear una nueva tabla con DAX que enumera cada uno de TODOS los valores distintos de una columna de la primera tabla con cada uno de LOS VALORES distintos de una columna de la segunda tabla. Como nota, estas dos tablas no están relacionadas de ninguna manera.

Tabla 1 Tabla 2 Tabla resultante
Columna 1 Columna 2 Columna 3Columna 4
1 A 1A
2 B 1B
2 B 2A
3 B 2B
3A
3B

Gracias

Mo

1 REPLY 1
parry2k
Super User
Super User

@mmoeller probar esto para crear una nueva tabla

New Table = 
CROSSJOIN (
VALUES ( Table1[Column1] ),
VALUES ( Table2[Column2] )
)

Apreciaría Kudos 🙂 si mi solución me ayudara.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors
Top Kudoed Authors