Forum Discussion

siva_powerbi's avatar
siva_powerbi
Icon for Helper IV rankHelper IV
6 years ago

devolver la tabla de dos comandos selectcolumn utilizando el constructor de la tabla

Hello experts   I have a requirement to combine every 2 columns of a table and then display the concatenated columns in a saperate table.   I am able to cross join and concatenate the result of t...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

@siva_powerbi, demasiadas uniones cruzadas. Por favor, háganos saber lo que está tratando de lograr.

¿Puede compartir datos de ejemplo y salida de ejemplo en formato de tabla? O una muestra de pbix después de eliminar datos confidenciales.

  • siva_powerbi's avatar
    siva_powerbi
    Icon for Helper IV rankHelper IV
    6 years ago

    I have added the sample data in the question, it is the data I am working on.

     

    My requirement is to out of 4 columns.

     

    Make cross join of col1, col2 and col2,col3 and col3,col4

     

    Then concatenate cross joins with "," and show the resultant values in a table side by side.

     

    I tried to attach the file but it doesn't carry the data in datasource, May I know the exact process.

     

    Thanks