Forum Discussion
CONCATENATE SUBSTR DAX MEASURE
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
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.
1 Reply
- AlexisOlson
Super User
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.