Forum Discussion
Slicer Week Offset USERELATIONSHIP Date
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
Dear Amitchandak,
you made my day. This it was I was looking for.
Thank you so much.
Andreas
4 Replies
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
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])
Dear Amitchandak,
you made my day. This it was I was looking for.
Thank you so much.
Andreas
