topic Re: Change Format on Measure Formula Result in DAX Commands and Tips

Change Format on Measure Formula Result

Sean-OReilly — Wed, 16 Sep 2020 15:25:55 GMT

How do i Remove the .00 from the below measure result?

Days to Ins Expiry = if([Today]<[Ins Exp Date],DATEDIFF([Today],[Ins Exp Date],day),"Expired")

Re: Change Format on Measure Formula Result

jthomson — Wed, 16 Sep 2020 15:46:34 GMT

Hmm, I would say just define the measure as a whole number in the measure formatting, but if you've got the possibility of it being text, then I guess that wouldn't work? Not sure why it's displaying .00 as that makes no sense in a datediff context, unless it defaults anything to having two decimal places. Try going INT(DATEDIFF([Today],[Ins Exp Date],day)) or TRUNC(DATEDIFF([Today],[Ins Exp Date],day)) perhaps?

Re: Change Format on Measure Formula Result

Sean-OReilly — Wed, 16 Sep 2020 16:01:47 GMT

Thanks J - the INT function at the start of the datediff formula done the trick