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 dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
17 | |
8 | |
7 | |
7 | |
6 |
User | Count |
---|---|
23 | |
11 | |
10 | |
9 | |
8 |