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:
Adding a measure or column as a tooltip to an Azur...
parry2k
on:
A Typo about Refence Line in the Format (Korean)
mattlee
on:
Automatically expand table columns to fill availab...