topic Help splitting this column in DAX Commands and Tips

Help splitting this column

Anonymous — Thu, 08 Feb 2024 11:13:34 GMT

I need to split this by dd/mm/yyyy (UK date format).

I'm in need of an DAX formula that'll extract the date portion (02022024) of the Source Name column and then return the result in the above manner.

If someone can guide me in this, it'll be wonderful. I'm very raw with DAX.

Re: Help splitting this column

govindarajan_d — Thu, 08 Feb 2024 11:51:59 GMT

Hi Anonymous,

Can you please try this:

Date = VAR DatePosition = LEN ( Files[FileName] ) - LEN ( "ddmmyyyy" ) - LEN ( ".xlsx" ) + 1 VAR DateString = MID ( Files[FileName], DatePosition, 8 ) RETURN FORMAT ( DATE ( RIGHT ( DateString, 4 ), MID ( DateString, 3, 2 ), LEFT ( DateString, 2 ) ), "dd/mm/yyyy" )

Upvote and accept as a solution if it helps!

Re: Help splitting this column

govindarajan_d — Fri, 09 Feb 2024 07:43:42 GMT

Hi Anonymous ,

Did the solution work?

Re: Help splitting this column

Anonymous — Wed, 21 Feb 2024 12:21:52 GMT

Hi, sorry for the very late response. I'm going to check now and get back to you.

Re: Help splitting this column

Anonymous — Wed, 21 Feb 2024 12:35:10 GMT

You're a star! Thanks.