Untitled
Anonymous
plain_text
08/14/2023 11:40 AM
536 B
22
Indexable
Revenues_Expenses =
VAR vDEST1 = MAX('Campos COSTES'[DEST1])
VAR vDEST5 = SELECTEDVALUE('Campos COSTES'[DEST5])
VAR vAmount =
IF(
vDEST1 = "REVENUES",
CALCULATE(SUM(Costes[COSTE_TOTAL]), Costes[EDC] = vDEST5),
IF(
vDEST1 = "EXPENSES",
CALCULATE(SUM(Costes[COSTE_TOTAL]), Costes[EDC] = vDEST5),
BLANK()
)
)
RETURN vAmount
Editor is loading...