Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Sathvik123
Helper V
Helper V

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. 

 

Sathvik123_0-1673347918576.png

 

 

3 REPLIES 3
v-rzhou-msft
Community Support
Community Support

Hi @Sathvik123 ,

 

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

RicoZhou_0-1673429113613.png

 

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.

 

Hi @v-rzhou-msft ,

 

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 

Greg_Deckler
Super User
Super User

@Sathvik123 The easiest way to do this would be to create a sequential column based on weeknum. Sequential - Microsoft Power BI Community

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.