Display the different.

Hi matrix_user ,

if you are able to add a date column (in the below code "Day Date" and create a relationship on this instead) in the fact table, this will enable time intelligence functions.

With Fact table[State] in matric values, you can create the following measures: 

1. Current Sold  = sum ( Fact table[Sold])

2. Current Remaining = sum( Fact table[Remaining])

3. SPLY Sold = Calculate( [Current Sold] , Dateadd( Date[Day Date]),-1,Year)
4. SPLY Remaining = Calculate( [Current Remaining] , Dateadd( Date[Day Date]),-1,Year)

5. Sold Change = [Current Sold] - [SPLY Sold]

This would solve the issue.

Appreciate a thumbs up if this is helpful.

Kindly accept this as the solution if your question is resolved.