Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Getting last week data dynamically

Hello All,

 

I need to create a dax where I can show last week data from sunday to saturday.

 

I have data like below.

So whenever in this week I ran the report I need to show only last weeks data as highlited below. 

 

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    You can try "Relative date" feature in [Date] column in Filter field. Show items when the value is in the last 1 calendar week.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Anonymous ,

       

      I need to do this using dax only as I have other filters also based on slicer selection

      liike If I select daily then yesterday

      weekly then last week

      monthly then last month