cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Combinar Colums

Hola a todos.

Mi problema actual es el siguiente:

Tengo 4 tablas de Excel diferentes, cada una de las cuales he creado una columna calculada a partir de enteros. (Valid_CSIS , Valid_Gen 8....)

Al final quiero tener las 4 columnas enteras de estas columnas calculadas en una sola tabla con una sola columna. ("Válido"

No puedo utilizar la función Unión porque todos los archivos de origen tienen un número diferente de columnas.

Forum_Bild.png

Gracias por su ayuda.

2 REPLIES 2
Highlighted
Super User IX
Super User IX

Re: Combinar colums

@Xneider ,

Puede crear tablas de dimensiones comunes en las 4 tablas y crear una medida combinada y usarla en objetos visuales junto con dimensiones comunes

Medida: sum(Table1[Valid_CSIS])+ sum(Table2[Valid_CSIS])+ sum(Table3[Valid_CSIS])+ sum(Table4[Valid_CSIS])

Otra forma de unión es dentro de la unión utilizar selectcolumns o resumir

Ejemplos

Resumen: UNION(
SUMMARIZE('Table1','Table1'[Customer],'Table1'[created_date],'Table1'[DA Status],'Sales",sum('Table1'[Sales]),"Invoices",count('Table1'[ID]),"Time",DIVIDE(SUM('Table1'[Ship Time]),1),"Stage"," Ship","Gross",sum('Table1'[inv_amount]),"Net",Sum('Table1'[Net Calc Amount]))
,SUMMARIZE('Table2','Table2'[Customer],'Table1'[created_date],'Table2'[AA Status],"Sales",sum('Table2'[Sales]),"Invoices",count('Table2'[ID]),"Time",DIVIDE(SUM('Table1'[Order Time]),1),"Stage","Order","Gross",sum('Table1'[inv_amount]),"Net",Sum('Table1'[Net Calc Amount]))
)

unión (
selectcolumns(table1,"ColA", table1[Column A],"ColA", table1[Column B],"ColF", table1[Column F]),
selectcolumns(table2,"ColA", table2[Column A],"ColA", table2[Column B],"ColF", table2[Column F])
)



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Super User IX
Super User IX

Re: Combinar colums

Utilice UNION excepto use SELECTCOLUMNS dentro de su UNION para:

Tabla ?

UNION(

SELECTCOLUMNS('Table1',"Value",[Value bla bla bla]),

SELECTCOLUMNS('Table2',"Value",[Value bla bla bla]),

SELECTCOLUMNS('Table3',"Value",[Value bla bla bla]),

SELECTCOLUMNS('Table4',"Value",[Valor bla bla])

)


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

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors