Calculation Difference Between Two Numbers in Two Tables Only

[Anonymous]

I am trying to compare the price of two different products across time, but on some dates I might not have price date for both products, so I want to exclude dates.  As you can see on the bottom of the picture, I didn't have both prices on September 3, so when I calculate to subtract those two numbers, it assumes that's a zero instead of omitting it.  

Here is my current calculation:

GAP = 'Daily Price 1'[$]-related('Daily Price 2'[$])

[mwegener · Accepted solution]

Hi,

with a if statement you can check if both prices exists.

GAP = IF( ISBLANK('Daily Price 1'[$]) || ISBLANK(RELATED('Daily Price 2'[$])), BLANK(), 'Daily Price 1'[$]-RELATED('Daily Price 2'[$]) )

The BLANK() GAP can be filtered on the visual level

[MattAllington]

There is a visual level filter you can set to filter out zeros etc.