I am having an issue with a DAX query where when I use the numbers directly I am getting the intended result but as soon as I use the numbers from the columns it is giving me an improper number. For example, when I use this
Amount =
VAR Result = 22294.16 * 0.04744
VAR TruncatedResult = FLOOR(Result, 0.001)
RETURN TruncatedResult
The amount is being returned properly as 1057.634, however when I put in the columns as seen below
Amount =
VAR Result = Table[Column1] * Table[Column2]
VAR TruncatedResult = FLOOR(Result, 0.001)
RETURN TruncatedResult
The truncated result is giving me 1057.635.
I have already checked and both columns when directly displayed are giving the proper and expected numbers, the issue only occurs when I am doing the multiplication with these columns though.
on:
URGENT!! Paginated Report not loading on Mozilla F...
mattlee
on:
“Add Value” in Textbox Not Visible in Dark Theme
on:
Bi Crashes on launch with (AS Process PID=XXXXXX H...
on:
Fix the Date function in DAX