Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ianallen13
Helper I
Helper I

Replace created date field

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. 

 

ianallen13_0-1641508867905.png

 

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

Hi, @ianallen13 

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

vangzhengmsft_0-1641870812636.png

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.

View solution in original post

2 REPLIES 2
v-angzheng-msft
Community Support
Community Support

Hi, @ianallen13 

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

vangzhengmsft_0-1641870812636.png

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
Super User
Super User

@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

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors