Column Formula Help

[CiaraCaryl]

So I have a calculated column that is currently adding two revenue numbers together to create credit for a specific team, theres been a change at my company and now if the revenue is coming from a marketing lead they only get 90% of the revenue credit, but if it is a self generated revenue then they get 100% credit so I need to know how to append the formula. 

I have a column that references if it is a marketing lead or not that returns a number if it is from marketing or a blank if it is a self generated deal. 

Essentially, If MQL = Not Blank, then ((Rev1 + Rev 2) * .9), If MQL = Blank, then (Rev1+ Rev2)
How would I write this in a calculated column formula?

[Anonymous]

Hi @CiaraCaryl ,

DataInsights provided you the formula of calculated column, please check if that can help you get the expected result. If yes, could you please mark his reply as Answered? It would be helpful to the others in the community if they face the similar problem as yours. Thank you.

If the formula is not working, please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. Please also provide their formula if [Rev1] and [Rev2] are the measures. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[DataInsights · Accepted solution]

@CiaraCaryl,

Try this calculated column:

Calculated Column =
IF (
    ISBLANK ( 'Table'[MQL] ),
    'Table'[Rev1] + 'Table'[Rev2],
    ( 'Table'[Rev1] + 'Table'[Rev 2] ) * .9
)