Forum Discussion
Help splitting this column
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 ...
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!
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!
Hi Anonymous ,
Did the solution work?
Hi, sorry for the very late response. I'm going to check now and get back to you.
You're a star! Thanks.