Forum Discussion
Help with Pivoting needed
Hello, I have a license log file, which among other columns, has Date and Status coulmns, see attached. When I pivot these and I choose to not Aggregate I get the error: "Expression.Erro...
Can you post a sample dataset which gives this error?
Here:
https://sabedin-my.sharepoint.com/:x:/g/personal/sabedin_bidatalab_com/EQhzCrCwjaZMlJ312apfOtUBFUMiCdPH0HRrXqx0GP7xKw?e=i3B7J6
Let me know if you don't see the file
Hi,
There are multiple IN and OUT on each date. For 10 Sep and 13 Sep, please show the exact result you are expecting.
I found a 'partial' solution here, I think you may want to know:
How to Pivot Column using Don't aggregate function with Power Query
