Hi there,
I have this data set with values in my differents columns that belong to same Dimension Set ID, is there any way I can consolidate this data in one single row?
This is what I have:
Dimension_Set_ID | AREADEPTO | ZONA | TIPO CTE | FAMILIA | LINEA |
3 | MAYORISTA | ||||
3 | Sup Ciudad de México | ||||
3 | GUERRA RICARDO |
This is what I want:
Dimension_Set_ID | AREADEPTO | ZONA | TIPO CTE | FAMILIA | LINEA |
3 | Sup Ciudad de México | GUERRA RICARDO | MAYORISTA |
I'm trying to achive this with Power BI, is that possible?
Could you point me to right direction?
TIA