I'm currently working on I project where I need to calculate the difference between two days to get that result and divided by the profit/loss to get the profit by day but when I use Datediff the result is not giving me the right result.
For Example:
| 22/3/2020 00:01 | 22/3/2020 19:24 |
| 3/3/2020 00:01 | 8/3/2020 13:12 |
In the example above the first line should be 0.807638888894871 but PBI is showing 0 and the second line should be 5.54930555559986 and PBI is showing 5. I tried to see if the number was hidden but when I unhide the decimals they are 0. I need the exact number to get an accurate result. Can anyone help me with this issue?
