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


     

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

Hi Anonymous 

 

Please see the attached file with a solution.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

    Mariusz 

    I can see that you are suming the values.

    I don't want to sum the values, I want in a way whereby I select a day, it will show me the trend values for each day for that week, and also show me the values that we have for those days previous week. 

    • 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