CONCATENATE SUBSTR DAX MEASURE

[ShortKing]

Hello, hope everyone had a good new years! Still a fairly new user to PBI, so help would be much appreciated!

I have used concatenate measure, but never with 4 other column formulas. How would this be translated from SQL to DAX measure?

DATE(SUBSTR(DIGITS(TABLE1),4,2) CONCAT '/' CONCAT SUBSTR(DIGITS(TABLE1),4,2) CONCAT '/ CONCAT SUBSTR(DIGITS(TABLE1),2,2)) AS MEASURE1

[AlexisOlson · Accepted solution]

This would probably be better to do in PowerQuery than DAX but if you do need it in DAX, use MID instead of SUBSTR.

DATE (
	MID ( Table1[Col1], 1, 4 ),
	MID ( Table1[Col1], 5, 2 ),
	MID ( Table1[Col1], 7, 2 )
)

If Table1[Col1] = 20231231, then the above should output 12/31/2023 as a date.