Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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
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]
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
Thank you that worked.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |