Replace created date field

[ianallen13]

Hello, 

I uploaded an excel file with records yesterday into SharePoint and it all worked out nicely, except for the created field now shows 1/5/2022 for all records.  When I open Power Bi and open my query editor, I see that the created column shows all records showing as 1/5/2022, when instead these records were created over the last several months (9/1/2021 - 1/5/2022) - how do I replace that date with the original created dates for each case?  I have those in an excel file and can match them up to the case numbers. 

I'm still a bit new to Power BI - so any assistance is appreciated. 

[v-angzheng-msft · Accepted solution]

Hi, @ianallen13 

Load your Excel file into PBIX, use the merge query, match the case numbers, click OK, and then expand Create Time Column.

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ianallen13 , Check the steps in the power query, Are you getting the corrected created date field from the source or not. Or is created in power query.

Ideally if it taking from source unless some step modify it, it should remain same