cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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] )

 

 

1 REPLY 1
Microsoft v-huizhn-msft
Microsoft

Re: Return on Ad Spend

Hi @ThePowerBIQueen,

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,742)