Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiply with difference columns based on a value

I have a query which need to multiply wiith different columns based on a column "Duration". Formula like this:   when duration is 1, I need to multiply commission amount, exchange rate and 1st year...
Need Help
  • Angith_Nair's avatar
    Angith_Nair
    5 years ago

    I have made a calculated column in the Power BI level. If you want to make this in Power Query then write the code like this..

    The result will be something like this..

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you so much for your help! But I can't use IF in the formula...

Angith_Nair's avatar
Angith_Nair
Continued Contributor
5 years ago

I have made a calculated column in the Power BI level. If you want to make this in Power Query then write the code like this..

The result will be something like this..

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi sorry, can I have one more question?

     

    As I was merged table for the exchange rate which have few months data when I unpivot the year the result will calculated all months of exchange rate for 1 case but I only want when 1 case appear then calculate the correct formula [amount * exchange rate * value].

     

    I don't know do you understand me....haha....but thanks anyway!