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.
Anonymous can you share sample data and expected result, will get you the solution. Reading at requirement and it look like something easy and not sure why it is not working for you.
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
