concatenate dax error

[Anonymous]

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]

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]

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 · Accepted solution]

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

[Anonymous]

excellent