Forum Discussion
Anonymous
5 years agoNot applicable
Linking table with date table
When I link a table with attribute [date appointment] to my data table, a lot of data gets lost somehow. I've done this with other tables too, but nothing gets lost there. With link to data tabl...
amitchandak
5 years agoSuper User
Anonymous , I think the problem is there with the date appointment has timestamp, Change the data type to datetime and choose a format with time, if you see any other time than 12 AM, it means there is a problem
Refer I discussed why Time intelligence fails
https://www.youtube.com/watch?v=OBf0rjpp5Hw
Anonymous
5 years agoNot applicable
Hi amitchandak, I had [date appointment] in Power Query as date, not timestamp. So it probably shouldn't be that.