pleeseemailme
Board Regular
- Joined
- Dec 26, 2013
- Messages
- 201
Howdy,
I am using Power Query to merge tables from several excel files into a master table. In these source tables there are two date columns A and B. Date column A contains only dates. Column B contains blanks, dates and sometimes text - always the text "Enter Date"
When I import the data into Power Query I change all the blanks and "Enter Date" values to null and then format the column to date. Then, in the merged table I have a step that reformats this column to a date.
From the master table I have created many pivot tables and charts, all of which are dependent on these date columns. With these pivot tables I have some timeline slicers set up as well.
For some reason, sometimes when the data is updated my slicers are deleted from my master workbook! When I check the master table (both in excel and power query) columns A and B are recognized as date columns.
The problem is, I can't find any consistency. I have 8 of these master table excel files (1 for each department) and some departments are always affected after an update, some are never affected some are sometimes affected. We update files once a week and I'm getting tired of reapplying all these slicers that go missing.
Can anyone help? Thanks so much in advance.
I am using Power Query to merge tables from several excel files into a master table. In these source tables there are two date columns A and B. Date column A contains only dates. Column B contains blanks, dates and sometimes text - always the text "Enter Date"
When I import the data into Power Query I change all the blanks and "Enter Date" values to null and then format the column to date. Then, in the merged table I have a step that reformats this column to a date.
From the master table I have created many pivot tables and charts, all of which are dependent on these date columns. With these pivot tables I have some timeline slicers set up as well.
For some reason, sometimes when the data is updated my slicers are deleted from my master workbook! When I check the master table (both in excel and power query) columns A and B are recognized as date columns.
The problem is, I can't find any consistency. I have 8 of these master table excel files (1 for each department) and some departments are always affected after an update, some are never affected some are sometimes affected. We update files once a week and I'm getting tired of reapplying all these slicers that go missing.
Can anyone help? Thanks so much in advance.
