Concatenate two numbers with decimal

[Anonymous]

I have two whole number columns that I would like to concatenate into 1 decimal column. For example, column A contains the value 2 (as in 2 months ago), and column B contains 1 (as in "the first week" of the month). I want the resulting calculated column to show 2.1 (2 months ago, first week of that month), formatted as a decimal. I tried the following:

FORMAT( Forecast[col1] & "."

& Forecast[col2], "##.#")

FORMAT( Forecast[col1] & "."

& Forecast[col2], DOUBLE)

However, when the column finishes calculating, it is still in text format, and when I try to change the data type, it says it cannot. I need to to sort as a number which is why I am trying to convert it.

[Sumanth_23]

hi @Anonymous, you can concatenate the 2 columns and then format the same as a whole number - please refer to the below screenshots 

Month-Day = 'Z-DateTime-Sort'[Month2] & 'Z-DateTime-Sort'[Day2]

You can hit proceed on the warning that pops up when you change from Text to Whole number

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[Anonymous]

It looks like what was happening is that I had another measure referencing this column as text with " " so it wasn't able to convert. I removed the references to this column and the conversion worked.