Forum Discussion

0xygen27's avatar
0xygen27
Advocate II
9 years ago
Solved

Filter Table

Dear all,   I would like to know how to filter out a table.    I got a table with multiple colums, some of them are Years, Description, Debet, Credit.   I want a measure that calculates the val...
  • Anonymous's avatar
    Anonymous
    9 years ago

     

    Delta := SUMX(
       FILTER(MyTable, MyTable[Description] = "KLM" && MyTable[Year] = 2017),
       MyTable[Debit] - MyTable[Credit]
    )