Forum Discussion
Linking multiple sheets via date
Figured it out!!
While I had edited the fields to all match date types. I then went into each table in query edit....the fields were NOT date type there.
Transformed them there, linked to date table...BOOM! all is well.
sample of results I should haveSample of data
I am trying to get all these tables I pulled in to link to a single date field. I then am counting them by iD. This way I can see how many 'items' in each table were created over a time frame.
Figured it out!!
While I had edited the fields to all match date types. I then went into each table in query edit....the fields were NOT date type there.
Transformed them there, linked to date table...BOOM! all is well.
I need to link dates from multiple sheets to create one slicer , but that's not working inspite of creating relationship
, Also all the dates have same date data type .
plz assist
