Forum Discussion

acerNZ's avatar
acerNZ
Icon for Helper III rankHelper III
6 years ago

Transpose of table doesn't work.. Says too large data.

Hi Experts Situation: I have about 60,000+ IDs and I have one of these tables, with each of these IDs in rows repeated about 30 times as key and values.  Objective: To make into columns ID and ...
Need Help
Show and Tell
Tutorial Requests
PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
6 years ago

Hi acerNZ

 

Do you want to show your data like below?

 

power query transpose

 

want to show data in POWER BI visualization or want to make it in POWER QUERY?

 

acerNZ's avatar
acerNZ
Icon for Helper III rankHelper III
6 years ago

Hi PijushRoy 

That is perfect but couple of things 

1. Date format has to DD/MM/YYYY

2. What is the best practices in Power BI / Data.. to have blanks on empty fields are fill it with null?

 

 

Thanks a lot

    • acerNZ's avatar
      acerNZ
      Icon for Helper III rankHelper III
      6 years ago

      Thank you PijushRoy  I will wait for Date stuff and executed your solution and I got the concept. When re-doing it, I have some issues may be I create seperate thread.