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])
johnt75's avatar
johnt75
Super User
3 years ago

Create a dimension table like

Fruits =
DISTINCT (
    UNION ( ALLNOBLANKROW ( 'Sheet1'[Fruit] ), ALLNOBLANKROW ( 'Sheet2'[Fruit] ) )
)

and link that to both tables in a one-to-many relationship with a single direction. Use the column from the new table on any visuals or filters and it should be fine.