Sales Dates for Prior Days Formula Assistance

poweras — Tue, 21 Feb 2023 21:45:00 GMT

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,

Re: Sales Dates for Prior Days Formula Assistance

FreemanZ — Tue, 21 Feb 2023 23:12:15 GMT

hi poweras

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

topic Sales Dates for Prior Days Formula Assistance in DAX Commands and Tips

Sales Dates for Prior Days Formula Assistance

Re: Sales Dates for Prior Days Formula Assistance