Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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,
hi @poweras
could you please provide a proper dataset with expected result? You may also provide your measure tried so far.
User | Count |
---|---|
69 | |
43 | |
21 | |
20 | |
14 |
User | Count |
---|---|
123 | |
42 | |
39 | |
26 | |
24 |