Forum Discussion
Convert data from multiple rows to one
Hello guys, I need to post this specific question to you to have some suggestions please. I have my source data (a stream of info about shipment tracking) formatted with multiple rows for eac...
I did not check the file yet. But can Unpivot help
https://radacad.com/pivot-and-unpivot-with-power-bi
Hi amitchandak thank you for your answer.
I tried the Pivot function ad in the sample dataset works correctly but in my dataset i always get an error and it doesn't work:
DataFormat.Error: Non è stato possibile eseguire la conversione in Number. Dettagli: 4625689281+4625684906I don't understand the reason, my real dataset has exactly the same structure (except for more other columns, but not relevant in this case).
Do you have any idea please?
Thank you for your time!
