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.
Hi Everyone,
Can someone explain this... I tried Editor as well to chagne the type to decimal but still having the issue where the calculations ignoring the decimals.
I am using this Custom Column Fromula and the expected result is 18.5 while I am getting 18.
if [Normal_Hours] = null or [Normal_Hours] = 0 or [OT_Hours] = null then
0
else if [Normal_Hours] + [OT_Hours] <= 10 then
[Normal_Hours] + [OT_Hours] +1
else
[Normal_Hours] + [OT_Hours]
Thank you in advance for your help.
Solved! Go to Solution.
It is sloved as my steps were not in order, I went back to Source and change data type to Decimal Type in advance Editor.
Tricky.
It is sloved as my steps were not in order, I went back to Source and change data type to Decimal Type in advance Editor.
Tricky.
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |