Forum Discussion
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...
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")
)
)
)
)
I got those errors, could you assist, please
Pic 1
Pic 2