Forum Discussion
AnSchmi
Helper II
Helper IISlicer 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
amitchandak
Super User
Super UserAnSchmi , 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])
AnSchmiDear Amitchandak,
you made my day. This it was I was looking for.
Thank you so much.
Andreas