DAX Formula Error for Text and number formatting

[Anonymous]

Hi Experts

I am trying to format the value column in FACT APst Due by adding a new calculated column.... see measure. Its not converting the % as percentage value and putting a ( ) around the negative number...

Can see my error.

See sample file...

https://www.dropbox.com/s/cdxsi40fukil83k/Test_.pbix?dl=0 

[Anonymous · Accepted solution]

Solved it

Value Formated = IF(TRIM('FACT Past Dues'[REGION])="Past Due %" ||

TRIM('FACT Past Dues'[Periods])="Jan 20 Act %" ||

TRIM('FACT Past Dues'[Periods])="Feb 20 Act %",

FORMAT('FACT Past Dues'[Value],"0.0%;(0.0%)"),

IF(TRIM('FACT Past Dues'[Periods])="Jan Act vs. Goal 2.0% (Fav / Unfav)" ||

TRIM('FACT Past Dues'[Periods])="Feb Act vs. Goal 2.0% (Fav / Unfav)",

FORMAT('FACT Past Dues'[Value],"0.0;(0.0) pts"), FORMAT('FACT Past Dues'[Value], "0.0;(0.0)")))