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 
    )
)


     

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

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1Column2
A1
B2.5

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Stachu  I have added some annoymized data.

 

So all I want to do is same day previous weeks.

 

As I stated earlier

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

    the days in the X axis are always showing just current week, correct? So looking at the report today (22-01-2020), with 3 weeks reference, the chart would be following:

    X axis - dates from 16-01-2020 till 22-01-2020

    Current week - values for dates 16-01-2020 till 22-01-2020

    PreviousWeek - value for 26-12-2019  shown in 16-01-2020 x axis, 27-12-2019  shown in 17-01-2020 x-axis, etc

    do I understand it correctly?

    • 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 
    )
)