Forum Discussion
how to multiply column with measure
In the above snip i am trying to multiply GR QTY column with measure actualval and displaying result in other measure Actualvalsaleafterpercentage but i m calcuating same value in calculator is coming different . how to get same value in powerbi .below formula i have used
[actualval]*[Quantity]
Please let me know
5 Replies
Is it possible that your actualVal measure has more decimal places than you are showing? For example, if the actualVal in your first row is actually 1.441990384 then that would explain it.
Greg_Deckler Hello Greg ,
I am showing exact 2 decimal places but still result is not showing correct.
OK, and I don't mean to needle but did you try increasing how many decimal places are shown by using the formatting ribbon? I have to ask to be sure because it's the only thing that makes sense.
Hi pokarman ,
What is the reason you choose to use the Value function, As far as I'm concerned, this function is purpose to Convert a text string that represents a number to a number. What is the return type of the measures [Quantity] and [actualval] and could you please share the folmula of those measures if it does not contain any confidential information? Have you tried to just ues ActualvalSaleafterpercentage = [Quantity] * [actualval] if those measure just return number?
Or we can use the following measure to force them calculated as 2-dial decimal number:
ActualvalSaleafterpercentage = Rounddown([Quantity],2) * Rounddown([actualval],2)
Best regards,Hi pokarman ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
