Forum Discussion
Daniel_Fdrvc
Helper I
Helper IConvert numbers to a specific look
Hi all, maybe some one know simple solution how to convert with DAX numbers from left column to a specific look in right column: Real Converted 112000 11.20.00 965600 ...
Daniel_Fdrvc - Looks like in Power Query you can use the technique found at https://community.powerbi.com/t5/Desktop/Power-Query-Insert-a-character-to-a-string/m-p/349199 .
You can do in DAX as:
Column = VAR length = LEN ( TableName[Real] ) RETURN LEFT ( RIGHT ( TableName[Real], length - 0 ), 2 ) & "." & LEFT ( RIGHT ( TableName[Real], length - 2 ), 2 ) & "." & LEFT ( RIGHT ( TableName[Real], length - 4 ), 2 )
ChrisMendoza
Resident Rockstar
Resident RockstarDaniel_Fdrvc - Looks like in Power Query you can use the technique found at https://community.powerbi.com/t5/Desktop/Power-Query-Insert-a-character-to-a-string/m-p/349199 .
You can do in DAX as:
Column =
VAR length =
LEN ( TableName[Real] )
RETURN
LEFT ( RIGHT ( TableName[Real], length - 0 ), 2 ) & "."
& LEFT ( RIGHT ( TableName[Real], length - 2 ), 2 ) & "."
& LEFT ( RIGHT ( TableName[Real], length - 4 ), 2 )