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.Error: There were too many elements in the enumeration to complete the operation."
What to do in order to have two columns: IN and OUT having all respective dates in Rows?
How did you apply pivot? You have to first click on the Status column, select Transform->Pivot Column, give Values as Date and Aggregate as Don't Aggregate. This should ideally work.
There are multiple IN and OUT on each date. For 10 Sep and 13 Sep, please show the exact result you are expecting.
To avoid above error, you could add an index column first, then, pivot table. But, as Ashish_Mathur said, how to deal with the multiple records on each day, please show us your desired output.
Using istructions from video above, I was able to create the ouput like this:
This is OK, but I lost information contained in other columns, therefore that solved my problem partially.
Ideally I would like Out and In columns, along with other columns that I have (not provided in sample dataset).
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!