Set Analysis, Multiple Expressions

[EvanBarrick]

I am attempting to get the sales for the past seven days for a particular type of buyer. 

Expressions 1: 

=SUM({$<promoCDE={"Adult"},}>}[Net Sold Qty])

Expression 2:

=SUM({<[Transaction Date]={">=$(=Date(max([Transaction Date])-7,'MM-DD-YYYY'))"}[Net Sold Qty]

When I combine, I get an error. Do I have the structure incorrect for either expression?

[marcus_malinow]

Have you tried out either of these expressions? I'm seeing syntax errors in both.

SUM({$<promoCDE={'Adult'}>}[Net Sold Qty])

SUM({$<[Transaction Date]={">=$(=Date(max([Transaction Date])-7))"}>} [Net Sold Qty])

Combined

SUM({$<promoCDE={'Adult'}, [Transaction Date]={">=$(=Date(max([Transaction Date])-7))"}>}[Net Sold Qty])

[marcus_malinow]

Have you tried out these expressions individually? I'm seeing slight syntax issues with both.

Would suggest the following:

SUM({$<promoCDE={'Adult'}>}[Net Sold Qty])

SUM({<[Transaction Date]={">=$(=Date(max([Transaction Date])-7))"}>} [Net Sold Qty])

and combined:

SUM({$<promoCDE={'Adult'}, [Transaction Date]={">=$(=Date(max([Transaction Date])-7))"}>} [Net Sold Qty])

[albert_guito · Accepted solution]

Try with

=SUM({<promoCDE={'Adult'},[Transaction Date]={">=$(=Date(max([Transaction Date])-7,'MM-DD-YYYY'))"}>} [Net Sold Qty]

Ag+

[albert_guito]

If you want to use separate the first has a comma and curly bracket at the end of modifier and the second needs to close the modifier with semicolom and other curly bracket