Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
SUM({$<Currency={EUR}, Date={'$(=Today())'}>}[Value])
same way if i want to put 3 expressions, i follow the same?