Forum Discussion

acerNZ's avatar
acerNZ
Icon for Helper III rankHelper III
5 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
acerNZ's avatar
acerNZ
Icon for Helper III rankHelper III
5 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
    5 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.