Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Adding two columns from different sheet (using a filter)

I am trying to add two columns / sheet from a different sheet for the dashboard, but running into a 'Blank' statement if the corresponding row doesnt exist in one of the columns / sheet. E.g.   Sh...
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    My Sum = SUM('Sheet1'[Amount]) + SUM('Sheet2'[payment])
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Doesnt work 😞

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    you'll need to be more specific, what result or error are you getting? can you share a sample PBIX ?