Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower 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
Icon for Community Champion rankCommunity Champion
2 years ago

ArchStanton 

use format (  your_measure_code , "##")

 

let me know if this works .

 

 

 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

  • ArchStanton's avatar
    ArchStanton
    Icon for Power Participant rankPower Participant
    2 years ago

    Hi,

     

    Using FORMAT breaks the code and my Average average disappears: 

     

     

     

    Case Length (Adj) Mths = FORMAT(
IF (
    'Cases'[statecode] = "Active",
    DATEDIFF (
        IF (
            ISBLANK ( 'Cases'[legacycasecreationdate] ),
            'Cases'[Created On],
            'Cases'[legacycasecreationdate]
        ),
        NOW (),
        MONTH
    ),
    DATEDIFF (
        IF (
            ISBLANK ( 'Cases'[legacycasecreationdate] ),
            'Cases'[Created On],
            'Cases'[legacycasecreationdate]
        ),
        'Cases'[Resolution Date],
        MONTH
    )
),"##")