Forum Discussion
Solved
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 Da...
Dear Amitchandak,
you made my day. This it was I was looking for.
Thank you so much.
Andreas
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'
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