To create date table for the week based on date selected from slicer

[kamalmsharma]

 I am trying to create two tables in Power BI report based on a date selected from the slicer. The first table needs to have dates for all days of the week belonging to the selected date. The second table needs to have all the dates of the previous week. Please help me to achieve this, 

[v-jiascu-msft · Accepted solution]

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

[kamalmsharma]

Hi v-jiascu-msft

Thank you so much for this excellent solution and sample file. It worked perfectly.  

Regards,

Kamal