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
poweras
New Member

Sales Dates for Prior Days Formula Assistance

Hi there, I'm trying to setup measures to get sales for prior days. For example, I would like to setup a formula to get total sales for the last 7 days. I have been using several suggestions, but the values are not showing any data or the matrix just continues to cycle. 

 

Here's a video for a formula I tried: https://www.youtube.com/watch?v=h_0v3rRDgU4

 

I setup a calendar that connects the sales date to the calendar date. Then I am using the calendar date for the intervals. But the matrix cycles continuously or displays an error. 

 

When I try to use this formula: https://radacad.com/week-to-date-calculation-in-power-bi-with-dax, I do not receive accurate information. Please help with this formula and let me know if you have any questions.

 

Thanks,

1 REPLY 1
FreemanZ
Super User
Super User

hi @poweras 

could you please provide a proper dataset with expected result? You may also provide your measure tried so far.

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.

Top Solution Authors