So i'm having a few issues trying to work out marketing expenses by category.
I have a table called "6201 Marketing Expense" and this contains the company's marketing expenses as "Debit"
the table has headers as follows:
Date, Supplier Account, Ref, Dept, Details, T/C, Type, Debit, Credit
date is self explanatory, supplier account is the list of suppliers, in this example i'll use "Rightmove", "Zoopla" and "ListGlobal" as the 3 items i want to focus on.
I know how to work out this formula in excel and SQL, but i'm having difficulty with the Dax statement.
What i want to calculate is the "Total Online Advertising cost", focusing only on Rightmove, zoopla and Listglobal entries in the table.
So far i have the formula as follows:
Solved! Go to Solution.
I think if you write it that way it effectively does a logical AND between the filter conditions (which will eliminate all the rows).
You could probably simplify this down to the following:
Online Ad Cost =
CALCULATE (
SUM ( '6201 Marketing Expense'[Debit] ),
'6201 Marketing Expense'[Supplier Account] IN { "Rightmove", "Zoopla", "ListGlobal" }
)
I think if you write it that way it effectively does a logical AND between the filter conditions (which will eliminate all the rows).
You could probably simplify this down to the following:
Online Ad Cost =
CALCULATE (
SUM ( '6201 Marketing Expense'[Debit] ),
'6201 Marketing Expense'[Supplier Account] IN { "Rightmove", "Zoopla", "ListGlobal" }
)