topic Re: How to replace decimal values but retain the original whole number in DAX Commands and Tips

How to replace decimal values but retain the original whole number

Rotcorp — Fri, 05 May 2023 12:42:47 GMT

I'm working with a netsuit timesheeting export that records a half fraction as .3

e.g. 37.5 hours a week shows as 37.3.
I have tried useing a conditional column to convert the .3 to a .5 but if the text contains .3 (else return the column value) however I can't figure out how to return the value before the decimal point

Am I using the correct method?

thanks in advance

Re: How to replace decimal values but retain the original whole number

tamerj1 — Fri, 05 May 2023 12:52:32 GMT

Hi Rotcorp

use the "Replace Value" option then manually edit thecode adding a conditional if statement and that says something like

each if Text.Contains ( [Column], ".3" ) then ".3" else null

Re: How to replace decimal values but retain the original whole number

mrcss23 — Fri, 05 May 2023 13:02:35 GMT

Hi. My suggestion is

1. Create a column that round down the value (column1) : Number.RoundDown([Total Hours])

2. Create a column2 that returns the decimal part, i.e.. [Column1] - [Total Hours]

3. Create column3 a which is [Column1]+0.5

4. Then make a conditional column

IF Column2 =0.7 than Column3

ELSE

[Total Hours]

Re: How to replace decimal values but retain the original whole number

Rotcorp — Fri, 05 May 2023 13:10:37 GMT

Thank you that worked.