Forum Discussion
To create date table for the week based on date selected from slicer
- 8 years ago
Hi kamalmsharma,
I hope you mean the table visual rather than the calculated table, which doesn't respond to the slicer.
Please download a demo from the attachment.
1. Create a slicer table without any relationship to other tables.
2. Create two measures.
thisWeek = VAR selectedDate = SELECTEDVALUE ( 'SlicerTable'[Date] ) RETURN IF ( ISBLANK ( selectedDate ), BLANK (), IF ( WEEKNUM ( MIN ( 'Table'[Date] ) ) = WEEKNUM ( selectedDate ), 1, BLANK () ) )previousWeek = VAR selectedDate = SELECTEDVALUE ( 'SlicerTable'[Date] ) RETURN IF ( ISBLANK ( selectedDate ), BLANK (), IF ( WEEKNUM ( MIN ( 'Table'[Date] ) ) = WEEKNUM ( selectedDate ) - 1, 1, BLANK () ) )3. Either adding the measures in the table or putting in the Visual Level Filter.
Best Regards,
Dale
Hi kamalmsharma,
I hope you mean the table visual rather than the calculated table, which doesn't respond to the slicer.
Please download a demo from the attachment.
1. Create a slicer table without any relationship to other tables.
2. Create two measures.
thisWeek =
VAR selectedDate =
SELECTEDVALUE ( 'SlicerTable'[Date] )
RETURN
IF (
ISBLANK ( selectedDate ),
BLANK (),
IF ( WEEKNUM ( MIN ( 'Table'[Date] ) ) = WEEKNUM ( selectedDate ), 1, BLANK () )
)
previousWeek =
VAR selectedDate =
SELECTEDVALUE ( 'SlicerTable'[Date] )
RETURN
IF (
ISBLANK ( selectedDate ),
BLANK (),
IF (
WEEKNUM ( MIN ( 'Table'[Date] ) )
= WEEKNUM ( selectedDate ) - 1,
1,
BLANK ()
)
)
3. Either adding the measures in the table or putting in the Visual Level Filter.
Best Regards,
Dale
Thank you so much for this excellent solution and sample file. It worked perfectly.
Regards,
Kamal