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...

Anonymous's avatar
Anonymous
Not applicable
5 years ago

That's work! Really thankssss!!!