Forum Discussion

Frequent Visitor

6 years ago

Solved

Multiply Columms

Hello! Anyone could help me, pls? I need to multiply two values, but they have a conditional. For example: I need to multiply the number of fruits per some tax, but the tax depends of the kind o...

Need Help

amitchandak
6 years ago
Information provided in a couple of posts, not making it clear. But summarize can help if data is at multiple levels

sumx(summarize(Table,Table[Fruit Name],"_Sum",sum(Table[Fruit Qty]),"_Max",Table[Tax]),[_Sum]*[_Max])

nataliafm31

Frequent Visitor

6 years ago

VasTg I can split - one table with "fruit_name" and Quantity and other table with "fruit_name" and its taxes and use a related function. The problem is that quantity is a calculated value and taxes is a function that depends of fruit type.

I can't share my data, it's confidential, but i will try to give a better example:

register_id type_of_fruit col_3 col_4 col_5
4512d banana ... ... ...

s345c3 apple
457120 orange
48762w apple

Then, I created some calculated measures: Banana_tax, Orange_tax, Apple_tax as float numbers (ex: Banana_tax = 0,07).

And so, I created a calculated columm, with the conditional I wrote before, to define the correct tax for each fruit. Finally, I want to multiply the correct tax X count(register_id) for each type of fruit.

I tried to use so many aproaches, but none worked until now 😞