30
Hello Professionals.
I kindly need your assistance to make a calculation in percentage value of a figure.
Example : I want to be able to do (calculate) in DAX
19.25% of 128901578.82 = < Answer >
Kindly note from the above, both 19.25% and 128901578.82 are already defined on a different column.
Best regards.
You can try below
Name DataType Subtype Length
DecValue Decimal
DecValue2 Decimal
documenttext Text
documenttext := '19.25%';
IF STRPOS(documenttext,'%') > 0 then
BEGIN
documenttext := DELCHR(documenttext,'=','%');
EVALUATE(DecValue,documenttext);
DecValue2 := 128901578.82;
DecValue := (DecValue2 * DecValue) /100;
END;
Hi,
Is 19.25% defined as text value?
Thanks.
#1
André Arnaud de Cal...
291,820
Super User 2024 Season 2
#2
Martin Dráb
230,514
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
