Forum Discussion

Chippy's avatar
Chippy
Frequent Visitor
1 year ago

Date Format

How can I make this text format in a dd mm yy format? Using the normal DateValue it seems to give me dates in future eg 7 Dec instead of 11 July?    
Show and Tell
Chippy's avatar
Chippy
Frequent Visitor
1 year ago

Thanks Phil, Yes, I took your approach and now using Power Query instead of the DAX and I seem to have more success.

 

Another query has come up, that is: my data is sourced from another 3rd party application, so I need to download the data in Excel. I tried downloading the data and saved over the old data, keeping the same file name but the BI model says, "The key didn't match any rows in the table". What would be the best practise for refreshing the excel data, to ensure all the added custom queries I have added in Query are preserved?

 

thanks

Chris

PhilipTreacy's avatar
PhilipTreacy
Super User
1 year ago

Hi Chippy 

 

Best to start a new post for a different problem and accept a solution for this one.

 

That error can indicate that names of sheets or columns are different in the file(s) you are trying to import compared to the initial file you used to set up the query.

 

Best practice is to keep all files you import with the same query to have exactly the same structure (e.g. sheet names, column names) and data types in the columns.

 

Regards

 

Phil