Forum Discussion
Split columns into rows
Hi guys, I am trying to create a Dax or something like this to split a columns into rows. I have this example of table: Nome do contratante CPF PARCEIRO Status Contrato Valor 1º repasse D...
Hi Anonymous ,
You could use SELECTCOLUMNS() and UNION() functions.
https://docs.microsoft.com/en-us/dax/selectcolumns-function-dax
https://docs.microsoft.com/en-us/dax/union-function-dax
Table 2 =
var Repasse1 = SELECTCOLUMNS('Table',"Nome do contratante",'Table'[Nome do contratante],"CPF",'Table'[CPF],"PARCEIRO",'Table'[PARCEIRO],"Status Contrato",'Table'[Status Contrato],"Valor Repasse",'Table'[Valor 1º repasse],"Data Repasse",'Table'[Data 1ª repasse],"Status Repasse",'Table'[Status 1ª Repasse],"Repasse",1)
var Repasse2 = SELECTCOLUMNS('Table',"Nome do contratante",'Table'[Nome do contratante],"CPF",'Table'[CPF],"PARCEIRO",'Table'[PARCEIRO],"Status Contrato",'Table'[Status Contrato],"Valor Repasse",'Table'[Valor 2º repasse],"Data Repasse",'Table'[Data 2º repasse],"Status Repasse",'Table'[Status 2ª Repasse],"Repasse",2)
var Repasse3 = SELECTCOLUMNS('Table',"Nome do contratante",'Table'[Nome do contratante],"CPF",'Table'[CPF],"PARCEIRO",'Table'[PARCEIRO],"Status Contrato",'Table'[Status Contrato],"Valor Repasse",'Table'[Valor 3º repasse],"Data Repasse",'Table'[Data 3º repasse],"Status Repasse",'Table'[Status 3ª Repasse],"Repasse",3)
Return
UNION(Repasse1,Repasse2,Repasse3)
Best Regards,
Jay
Hi Anonymous,
Many thanks for your reply, but it's not exactly what we need. We have the first table, and we need to split into rows when the column Data Repasse is filled.
Hi Anonymous ,
What do you mean "when the column Data Repasse is filled"?
Best Regards,
Jay