substr
1 Topic
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 MEASURE1Solved565Views0likes1Comment