Format a column values in table

[Anonymous]

Hi, I have a calculated column to show

"OK" for matching values of column 1 and column 2

"NF" for missing column 2 values

(Column 1 - Column 2) for rest of rows . I am unable to format numbers. I need to show values like below example (highlighted in bold)

Example:

Column 1     Column 2    Calculated Column result

$1,000.00     $1,000.00     OK

$1,000.00                         NF

$11,000.00     $9,000.00   $2,000.00

[MFelix · Accepted solution]

Hi @Anonymous,

The problem you are having is that the column/measure as two different type of values text and numbers in this case the measure is treated as text so the numbers will not have the correct format you need to setup a measure where you pass the format to the final result.

Try something like this:

Column =
IF (
    Table1[Column1] = Table1[Column2];
    "OK";
    IF (
        Table1[Column1] = BLANK ();
        "NF";
        IF (
            Table1[Column2] = BLANK ();
            "NF";
            FORMAT ( Table1[Column1] - Table1[Column2]; "$#,###.00" )
        )
    )
)

See result below:

Regards,

MFelix