
Active Member

July 31, 2014

I am downloading custom files from Salesforce that have time stamped collection periods. It downloads in Day/time format down to the minutes. I re-format in Power Pivot, but I still get a lot of data that comes out as blanks which tells me the formatting isn't identifying with each other. I can't seem to find what I am doing wrong since I am formatting the date fields in the date table and Salesforce the same. If I form a pivot table with just the data, outside of power pivot, it doesn't have a issue. I have tried forming my own date table and also using the one available in excel 2016.
Any suggestions would be appreciated.


July 16, 2010

Hi Paul,
When you say you reformat in Power Pivot, what are you doing to reformat exactly?
Do you have a sample of the dates that are misbehaving that you can share. We only need a column of dates that includes some that get returned as blanks. If you can share a sample Excel file where you've loaded the dates into Power Pivot and they return blanks, then we can troubleshoot.
I suspect the dates are in the source as mm/dd/yyyy and your system is dd/mm/yyyy or vice versa, so please also tell us what your region settings are for dates and that of the SQL source.
Mynda

Active Member

July 31, 2014

I realize that when I get comfortable with Power Query I will merge several of the year over year collection documents, but for now just trying to resolve the date issue.
I am including my Dashboard workbook that has all the documents in power pivot.
Also, two stand alone workbooks, 2017 collections and the date table I created.
Thanks and I look forward to seeing my errors.
1 Guest(s)
