'DATE' has the wrong data type or the result is too large or too small

[gmazza76]

Good morning all,

Its a bit early, but I have been trying to remedy this error since yesterday and its time I asked for some help

I have imported a '.csv' file into Power Pivot and need to amend the current "date" format as it has been pulled through as a "text" data type.
I am fairly new to Power Pivot so any help would be appreciated.

I am using the formula

=date(left('TabName'[F4], 4), mid('TabName'[F4], 6, 2), mid('TabName'[F4], 8, 2))

thanks in advance

 

[gmazza76]

I also have tried

=date(LEFT('TabName'[F4],4),MID('TabName'[F4],6,2),RIGHT('TabName'[F4],2))

 

[sandy666]

if you want current date try: TODAY()

 

[gmazza76]

if you want current date try: TODAY()

I need to amend the date in text format in column [F4] to an actual date so I can use calculations on the column going forward

 

[sandy666]

try DATEVALUE([F4]) but I think you'll get error
why not Power Query? set all columns to the proper format then add table to data model

 

[gmazza76]

I have managed to sort this thanks for your time.
I have used Power Query to change the format

 

[sandy666]

I have used Power Query to change the format

that is what I said,

why not Power Query?

btw. in Data Model after import csv the first row in F4 column is..? any text or date? (without filtering anything)

 

[sandy666]

maybe you forgot about this

that is why you've column headers as F1, F2, F3, F4 .... etc

 

[gmazza76]

thanks sandy666, I re worked the upload correctly and it seems to have worked as well as allow me to amend the dates.

Are you able to look at my current post on Power BI and see if you can point me in the right direction?

Its called "Countifs / Match Query in Power BI"
thanks