Forum Discussion

mhablas426's avatar
mhablas426
Advocate II
2 years ago
Solved

Dynamic Format values

Dears I would like to complete that format to include minus signs in front of negative values. the expected result to be (-1.2m) ,(-12.5K) Thanks, DAX format I used: IF (     [Samperiodlast ye...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    mhablas426 , Try this measure

    FormattedFuelQuantity =
    VAR Quantity = 'Fuel Formulas'[Fuel Total Quantity]
    RETURN
    IF (
    Quantity >= 1000000,
    FORMAT(Quantity, "0,,.00 M"),
    IF (
    Quantity >= 1000,
    FORMAT(Quantity, "0,.00 K"),
    IF (
    Quantity <= -1000000,
    FORMAT(Quantity, "0,,.00 M"),
    IF (
    Quantity <= -1000,
    FORMAT(Quantity, "0,.00 K"),
    FORMAT(Quantity, "0.00")
    )
    )
    )
    )

     

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi mhablas426 - Can you try the below measure to report the expected result with () for negative

 

Formatted Value =
VAR Value = [Samperiodlast year Variance]
RETURN
IF(
ABS(Value) >= 1000000,
IF(Value < 0,
"-" & FORMAT(ABS(Value) / 1000000, "0.0") & "m",
FORMAT(Value / 1000000, "0.0") & "m"
),
IF(
ABS(Value) >= 1000,
IF(Value < 0,
"-" & FORMAT(ABS(Value) / 1000, "0.0") & "K",
FORMAT(Value / 1000, "0.0") & "K"
),
FORMAT(Value, "0.00")
)
)

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!