Forum Discussion
Linking multiple sheets via date
I have pulled in multiple data sources from SharePoint 365. I am trying to build some stacked visuals as well as pie charts. Each sheet is unique in what it captures, except for Id field and ...
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.
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.
BANU
Helper I
Helper II 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