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,
