Slicer Week Offset USERELATIONSHIP Date

[AnSchmi]

Hi Team, 
I have a simple model of orders and date table. The orders table contain open date as well as commitment date. 
I do not manage to calculate and show in Slicers the Week Offset of Open Date and Commitment date using userelationship. 
My model looks like this 

And what I want to achieve is the Week Offset of Commitment Date

Any help is highly appriciated. 
Stay save 
Thanks a lot
Andreas

[amitchandak]

@AnSchmi , Here you need two date tables or you need calculate offset in the table.

Or create calculated columns in your table f order

column 1 =

maxx(filter('D calendar', 'f order'[commitment date] = 'D calendar'[Date]), 'D calendar' [Week offset])

column 2 =

maxx(filter('D calendar', 'f order'[Order date] = 'D calendar'[Date]), 'D calendar' [Week offset])

[AnSchmi · Accepted solution]

Dear Amitchandak,
you made my day. This it was I was looking for. 
Thank you so much. 
Andreas

[Anonymous]

By Week Offset of Commitment Date, do you mean the difference betweens todays week and the week of Commitment date?

Can you include your DAX for both 'CurWeek Offset' and the 'Week Offset Date.Commitment'

[AnSchmi]

Dear Nickolajj, 
thanks a lot for your immediate response. 
Amitchandak already presented the solution by adding two columns to the fact table. 
There is no DAX code, because Week Offset is taken from Calendar table. 
Have a nice day.
Best Regards
Andreas