multiple expressions in Sum Function

[#1]

hi all,

i am trying to sum my value based on 2 columns : 1 is currency and 2 is date

So my raw data has 3 columns Date, Currency and Value and if i make a straight table for 1 dedicated currency

i select dimension as Date and Currency and in expression i have SUM({$<Currency={EUR}>}[Value]) and i gives correct data, but i need to include Date = today() also in sum expression.

is it possible?

thanks

[alexandros17 · Accepted solution]

try this

SUM({$<Currency={EUR}, Date={'$(=Today())'}>}[Value])

[#3]

same way if i want to put 3 expressions, i follow the same?