Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

concatenate dax error

Hi Experts

Not sure what i am doing worng here, i want to be able to show a concatentate formula that produce the following output based on certain columns.

Column A= Stembrand (String Polarstem)

Column B= Primaryyearsoutcome (all value are in the format 7.5)

Result in new column should read Polarstem7.50000 (not as per current DAX)

As you can see i have appended four 0000 to the end..

my dax is

EMYEARS = CONCATENATE(Sheet1[STEMBRAND],FORMAT(Sheet1[PRIMARYTOOUTCOMEYEARS],"0000")

Anonymous
7 years ago
Hi Anonymous ,

Please see the below example.

Column = CONCATENATE(Sheet3[Category2], LEFT(Sheet3[Value2]&"0000",7))
Column = CONCATENATE(Sheet3[Category2], LEFT(Sheet3[Value2]&"0000",7))

Thanks

4 Replies

Anonymous
Not applicable
7 years ago
Hi Anonymous ,

You can use below below DAX column, this will add "0000" at the last

EMYEARS = CONCATENATE(Sheet1[STEMBRAND],Sheet1[PRIMARYTOOUTCOMEYEARS]&"0000")

If the value for PRIMARYTOOUTCOMEYEARS is like 7.55 then above DAX will show the value Polarstem7.550000. If you need exact 5 digits after dot then you need to use below DAX formula

EMYEARS = CONCATENATE(Sheet1[STEMBRAND],LEFT(Sheet1[PRIMARYTOOUTCOMEYEARS]&"0000",7))

If this helps and solve your problem then mark this as solution and give khudos.

Thanks
- Anonymous
  Not applicable
  7 years ago
  Hi Sunil
  
  The 7.5 was any example i have values the are 0.0, 1.2, 3.4 and so in primary years how dose the second dax work please.
  - Anonymous
    Not applicable
    7 years ago
    Hi Anonymous ,
    
    Please see the below example.
    
    Column = CONCATENATE(Sheet3[Category2], LEFT(Sheet3[Value2]&"0000",7))
    Column = CONCATENATE(Sheet3[Category2], LEFT(Sheet3[Value2]&"0000",7))
    
    Thanks

Related content