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
- kamalmsharma8 years ago
Helper II
Thank you so much for this excellent solution and sample file. It worked perfectly.
Regards,
Kamal