Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

negative value in bracket

Hi, I have a column that is called "project". its format is decimal number. I want to show negative values with brackets. I tried to make a measure (Measure=FORMAT([Project];"##,###;(##,###);-") Th...
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    IF ,

    What is [Project] exactly? Is it Measure or just a fields or Calculated column?

    If it is field from table so try to use aggreagation like SUM,MAX etc.

     

  • Tahreem24's avatar
    Tahreem24
    6 years ago

    IF ,

    Use the below DAX:

    MEASURE = IF(SUM(Sheet6[Value])<0,"("& SUM(Sheet6[Value])&")", SUM(Sheet6[Value]))
     
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Or you can also try using Dax:

= IF([Project]<0,&"("& [Project]&")", [Project])

 

  • IF's avatar
    IF
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    Hi,

    When I type [Project], the power bi doesn't recognize it. it underlines it with red unfortunatelly.

    • Tahreem24's avatar
      Tahreem24
      Icon for Super User rankSuper User
      6 years ago

      IF ,

      What is [Project] exactly? Is it Measure or just a fields or Calculated column?

      If it is field from table so try to use aggreagation like SUM,MAX etc.

       

      • Tahreem24's avatar
        Tahreem24
        Icon for Super User rankSuper User
        6 years ago

        IF ,

        Use the below DAX:

        MEASURE = IF(SUM(Sheet6[Value])<0,"("& SUM(Sheet6[Value])&")", SUM(Sheet6[Value]))