Remove decimals in a concatenated column

[Anonymous]

Dear all,

I have a text column (ID) and Decimal column (LINENUM) wih 0 decimals which I concatenate with each other.

The problem with this is that the column suddenly shows decimals when I combine them:

I tried two different functions and both did not work. I used CONCATENATE() and COMBINEVALUES() but both show same result. 

Does anyone know how I can remove the decimals in the new concatenated column?

Thanks!

[iXpert_info]

Hello @Anonymous 

Can you try the below DAX 
ContractLine= CONCATENATE(ID,round([LineNum],0)

Please accept this as solution if this helped to help others

Best Regards
Jay Patel
iXpert Analytics

[Anonymous]

Hi @iXpert_info ,

I tried your DAX but this also shows the same results alas. 

[harshnathani]

Hi @Anonymous ,

Try Column by Example in Power Query

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-add-column-from-example

Do let me know if this works

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)