Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DAX formula

I want to remove "demand.00" from values section. I tried INT and  ROUND function to solve but nothing worked. If I'm changing it to integer then "3M MDS % change" is also changing to integer, ...
"DAX Commands and Tips"
"DAX"
  • SachinNandanwar's avatar
    SachinNandanwar
    2 years ago

    Have you tried FORMAT function ?

    FORMAT(YourValue, "0.0") & "%"
  • Anonymous's avatar
    Anonymous
    2 years ago

    Sorry but it is still showing same as above.

     

  • Anonymous's avatar
    Anonymous
    2 years ago

    Yes, I tried. 

    IF(ISBLANK(MAX(Append1[Month-Year]))=FALSE(),
            IF(DISTINCTCOUNT(Append1[Month-Year])>1,
            FORMAT(Change, "0.00") & "%",
            FORMAT(SUM(Append1[Demand]), "")
            )
        )
    and it worked. 
    Thankyou so much.
     
  • SachinNandanwar's avatar
    SachinNandanwar
    2 years ago

    Great. Please mark my solution as solved.

SachinNandanwar's avatar
SachinNandanwar
Icon for Impactful Individual rankImpactful Individual
2 years ago

Have you tried FORMAT function ?

FORMAT(YourValue, "0.0") & "%"
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes, I tried. 

    IF(ISBLANK(MAX(Append1[Month-Year]))=FALSE(),
            IF(DISTINCTCOUNT(Append1[Month-Year])>1,
            FORMAT(Change, "0.00") & "%",
            FORMAT(SUM(Append1[Demand]), "")
            )
        )
    and it worked. 
    Thankyou so much.
     
    • SachinNandanwar's avatar
      SachinNandanwar
      Icon for Impactful Individual rankImpactful Individual
      2 years ago

      Great. Please mark my solution as solved.