Sales Dates for Prior Days Formula Assistance

[poweras]

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,

[FreemanZ]

hi @poweras 

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