Change Data Type in Specific Rows

[ExtraRice]

I have a table that is transponsed from Rows to Column to Colum to Rows.  Is it possible to change data type on specific rows from a transposed table.

Here is the transposed table: 

Thank you

[v-polly-msft · Accepted solution]

Hi @ExtraRice , 

Please refer to my pbix to see if it helps you.

Create two measures.

2022/01 =
VAR small_0 =
    IF (
        MAX ( 'Table'[2022/January] ) < 1,
        FORMAT ( MAX ( 'Table'[2022/January] ), "percent" ),
        MAX ( 'Table'[2022/January] )
    )
VAR _large_0 =
    IF (
        MAX ( 'Table'[2022/January] ) > 1,
        FORMAT ( MAX ( 'Table'[2022/January] ), "0.0000" ),
        MAX ( 'Table'[2022/January] )
    )
RETURN
    IF ( MAX ( 'Table'[2022/February] ) < 1, small_0, _large_0 )

2022/02 =
VAR small_0 =
    IF (
        MAX ( 'Table'[2022/February] ) < 1,
        FORMAT ( MAX ( 'Table'[2022/February] ), "percent" ),
        MAX ( 'Table'[2022/February] )
    )
VAR _large_0 =
    IF (
        MAX ( 'Table'[2022/February] ) > 1,
        FORMAT ( MAX ( 'Table'[2022/February] ), "0.0000" ),
        MAX ( 'Table'[2022/February] )
    )
RETURN
    IF ( MAX ( 'Table'[2022/February] ) < 1, small_0, _large_0 )

If I have misunderstood your meaning, please provide your pbix file and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ExtraRice]

This is what is needed!!! Thank a lot!!!!

[amitchandak]

@ExtraRice , I doubt one column can have two data types of the decimal place. You can create a measures return different values