How to display inactive date in a table

[JemmaD]

I have a fact table with two dateids: INCEPTIONDATEID and EXPIRYDATEID
These are not dates but numerical columns.

I have a date dimension table with DATEID and a Start of Month column which displays only the month and year of the DATEID

I have an active relationship between INCEPTIONDATEID and DATEID and an inactive relationship between
EXPIRYDATEID and DATEID

So in my table, I can show Inception Month by brining in Start of Month from the date dimension table, because of the active relationship between the two dates. 

However I also want to display the expiry month. Without manually creating an expiry month and year column in the Fact table, I have no idea how to do this - I figure I need to create a calculated column perhaps in my date dimension table which uses the relationship between EXPIRYDATEID and DATEID but I don't know how to go about this.

Help please!

[mh2587]

use the userrelationship function and values function to create the calculated column 

[JemmaD]

@mh2587 I figured I need to do this, but I don't now the sytax for creating the calculated column. Are you able to help me write it?