Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Formatting Show Numbers as Numbers and not Text Values

Hi Experts

 

Is it possible to re-write following measure so the numbers are show as number and not text as the same with the percentage section in the DAX too.

Q1-19Act. = IF(TRIM('Mar21'[ItemGrp])= "%",
FORMAT('Mar21'[Q1-19 Act],"0.0%;(0.0%)"),FORMAT('Mar21'[Q1-19 Act],"0.00;(0.00)"))
Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    No, the result of a measure always needs to have the same data type.  What's wrong with text?