Forum Discussion
swolfe2
1 year agoHelper I
Dynamic Measure Formatting Negative Values with Parentheses Instead of (-)
I am attempting to do some dynamic measure formatting on a DAX measure. However, I'm having difficulty getting negative values to display with parentheses instead of the negative symbol.
For example, if I have a value of -132,500,000, I want to display it as ($132) M.
The dynamic measure formatting is working great for positive numbers, I'm just unsure how to get it to display correctly with negative values.
VAR CurrentValue = SELECTEDMEASURE()
RETURN
SWITCH (
TRUE(),
CurrentValue <= -1000000, "($#,0,,.) M",
CurrentValue > -1000000 && CurrentValue < 0, "($#,##0)",
CurrentValue >= 0 && CurrentValue < 1000000, "$#,##0",
CurrentValue >= 1000000, "$#,0,,. M"
)
Hi swolfe2
I would recommend this:
VAR CurrentValue = SELECTEDMEASURE() VAR AbsValue = ABS ( CurrentValue ) RETURN IF ( AbsValue >= 1000000, "$#,0,,. M;($#,0,,.) M", "$#,##0;($#,##0)" )This makes use of the "<positive format>;<negative format>" structure.
Does this work for you?
2 Replies
- swolfe2Helper I
Worked perfectly, and is an elegant solution. Thanks so much!