Hi Mynda

I've created a measure called 'Change in Service Provisions' that is as follows: -

=If([Most recent transactions] = [Previous period transactions],
   Blank(),
    "Check for change in Service Provision"
   )

Where [Most recent transactions] measure is: -

Calculate (
     Sum('Accounts table'[Amount posted]),
      Filter('Accounts table'[journal date]=
       Max('Accounts table'[journal date])
      )
)

And [Previous period transactions] is the same as [most recent transactions] less 14 days (the previous pay run).

The IF measure works well where a client is present on the latest and previous pay run returning "Check for change in Service Provision" where two values are not the same. The problem I have is when the client is not appearing in the latest and previous pay run. In these instances, it is still returning "Check for change in Service Provision". I've set up the Pivot table so I can see both the "most recent transaction" measure and "previous period transaction" next to the "Change in Service Provision" measure to see what is happening. Where the client is not appearing in the accounts table on these payment run, the value in the pivot table is blank and when I hover over that point it says "value: no value".
Is there anyway I can prevent the IF statement from returning the "Check for Service Provision" when no values exist in the two measures it is comparing? Thank you.

Tim