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]),"##")



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.