Forum Discussion

JamesCoco's avatar
JamesCoco
Regular Visitor
5 years ago

Filter columns and compare dates

I have a SharePoint list with about 30 date columns, each representing a document in our library. Each employee adds their name to this list and the date that they have read each document.   I then...
Need Help
JamesCoco's avatar
JamesCoco
Regular Visitor
5 years ago

 

Hi Rena, this seems to be what I'm looking for, however, I'm running into errors when unpivoting from my SharePoint list. As soon as I unpivot the columns, I get errors in every column, as displayed.

 

I tried creating a brand new list, but had the same problems. Perhaps a problem when sourcing from a SharePoint list?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi JamesCoco ,

How did you execute unpivot step in Power Query Editor? Please review the content in the following link and check whether they can help you resolve the problem.

sharepoint loading error (A value without a type name was found and no expected type is available)

If the above one is not working, please provide your sample pbix file(exclude sensitive data) in order to make troubleshooting and find the solution. Thank you.

Best Regards