Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Same day Previous week

tbl_dt btx clp lwp 11/9/2019 890 34 55 11/10/2019 232 142 159 11/11/2019 4455 127 170 11/12/2019 433 113 133 11/13/2019 3456 158 69 11/14/2019 445 107 ...
  • Stachu's avatar
    Stachu
    6 years ago

    Anonymous actually measure used by Mariusz will work for you if you add minus for the day offset (here adjusted for your table)

    Measure = 
CALCULATE(
    SUM( 'Table'[lwp] ),
    DATEADD( 
        'Table'[tbl_dt], 
        - MAX( 'Week Slicer'[Week No] ) * 7, 
        DAY 
    )
)


     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Stachu 

X-axis will show the current week with the line trend, that is 17/01/2020 to 23/01/2020, while the other line trend hovering over will show previous week like from 10/01/2020 to 16/01/2020(although this can be for last week, last 2weeks i.e 03/01/2020 to 09/01/2020) etc.

 

Hope I am clear enough.

 

Thanks for your input thus far.

Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous actually measure used by Mariusz will work for you if you add minus for the day offset (here adjusted for your table)

Measure = 
CALCULATE(
    SUM( 'Table'[lwp] ),
    DATEADD( 
        'Table'[tbl_dt], 
        - MAX( 'Week Slicer'[Week No] ) * 7, 
        DAY 
    )
)