Forum Discussion
Helper IIDate Table not working with relationship
There appears to be two different places to format data.
When using Get Data and bringing in the initial SharePoint list the Date columns come as Any\Text. I had initially left it like that and made my Date table and joined them. I initally tried changing the data type in the relationship area. That didn't have the desired effect. Only after going back to the Sharepoint list data and modifying the CreatedBy column from Text to Date did it start working.
Helper IIThe query for Sharepoint list has the time stamp. I thought by changing the data type and so on this would work. Do I need to change it in the query instead? I thought that would create to much load time.
Community ChampionI would convert it as its obviously not working. create a new column only with date values. ie duplicate that column, and then from the transform menu in power query change it to date / then date only to make sure
something is obviously not matching up, make sure they are both only dates not datetime in datatype too