Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
2 years ago
Solved

Cannot remove decimal places

Hi,   This is driving me mad, hope someone can help! The code below defaults the Average Months to 2 decimal places - I don't want any decimals.   Case Length (Adj) Mths = IF ( 'Cases'[sta...
Need Help
Show and Tell
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    ArchStanton 

    Measure = FORMAT(SUM(Table[Case Length (Adj) Mths]),"##")



PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi ArchStanton 

Please use a measure 

 

Measure = FORMAT([YourMeasure],"##")


Let me know if that works for you

 


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    2 years ago

    Hi, I've responded to Daniel above who proposed the same solution. It does not work as I am summarising the calaculated column by 'Averaging'.

     

    FORMAT breaks the code and I do not have the option to see a Summarised value anymore only Counts

    • PijushRoy's avatar
      PijushRoy
      Community Champion
      2 years ago

      Hi ArchStanton 

      Dont change your existing measure
      Create a another measure use 

      Measure = FORMAT([Case Length (Adj) Mths],"##")

       

      If your requirement is solved, please mark THIS ANSWER as SOLUTION

       

      • ArchStanton's avatar
        ArchStanton
        Power Participant
        2 years ago

        Case Length (Adj) Mths is a calculated column not a measure

         

        It was initially calculating DAYS but I created a copy and changed the Parameter to MONTH earlier today

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    ArchStanton 

     

    convert(format( your_measure, "##" ) ,integer) 

     

     

    pattern : 

     

    • ArchStanton's avatar
      ArchStanton
      Power Participant
      2 years ago

      Thanks Daniel, I managed to get the answer from the other helper on this thread, I was dealing with a calculated column not a Measure.

      Thank you for helping anyway.