Combine percentage and integer datatype in the same calculated column

DAX DAX Calculations
1

Hi!

I have made a calculated table where all 3 rows are integers. I want to change the datatype for row 2 to a percentage but keep failing. Is this even possible to achieve in a calculated table?
I have tried Convert, Format and concatenating a “%”, but none work.

I have achieved the desired outcome in a different scenario where I added a row through M to an imported table and then changed it to % through DAX, but since this table is calculated I don’t have that option.

image

2

For others that might run into the same problem, I solved it by converting the columns to text, and then using the Convert function on rows 1 and 3, allowing me to manipulate how row 2 is presented.

image
image853×169 10.3 KB