Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Multiply in different conditional

I have a big data below is just a sample:

 

Status | Annual Amount | Paid Amount | Exchange rate | Factor | Total
A        | 2400                   | 2000              | 7.8                   | 12       | Annual Amount x Exhchange rate x Factor
B        | 3270                   | 620                | 7.8                   | 12       | Paid Amount x Exhchange rate x Factor

 

How to write a formaul when Status =A or B then Total = above formula, the result need to show in the same column. Thank you!!!

1 ACCEPTED SOLUTION
jennratten
Super User
Super User

Here you are...

= Table.AddColumn(Source, "Total", each if [Status] = "A" then [Annual Amount] * [Exchange Rate] * [Factor] else [Annual Amount] * [Exchange Rate] * [Factor], Currency.Type)

If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.

Proud to be a Microsoft Fabric Super User

View solution in original post

1 REPLY 1
jennratten
Super User
Super User

Here you are...

= Table.AddColumn(Source, "Total", each if [Status] = "A" then [Annual Amount] * [Exchange Rate] * [Factor] else [Annual Amount] * [Exchange Rate] * [Factor], Currency.Type)

If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.

Proud to be a Microsoft Fabric Super User

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.