Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Return on Ad Spend

What information is needed to determine the ROAS? 

 

The formula I have is [NPV Sum] - [Expense Sum] ; but the values do not look correct. 

 

[NPV Sum] = Sum( 'SalesTable' [NPV Value] )

[Expense Sum] = Sum( 'VendorTable' [Expense] )

 

 

Need Help

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    It's hard to reproduce your scenario without more details. Do you mind share your sample table? If your table is confidential, you can create some fake data similar with your actual data. It said the result of the formula is uncorrect? And what is the correct result? 

    Best Regards,
    Angelia