This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hello Guys,
I'm stuck with a problem where I need to show the last week total for all of the upcoming weeks.
in The image you can see the last available data for the week is week 12 which I want to show for all of the upcoming weeks untill new data has been added. I have used lastdate function to get the last order date then used dateadd to get the value of 7 days ago but it isnt showing the correct result. Also I can't show the last week value for all of the upcoming blank weeks.
Can you please help me with this problem.
@CConsultants1 , refer if week rank approach can help
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
I'll surely try to use that method. But here the problem is I have to show the last week value as a forecast for all of the upcoming weeks. Can you please help me on that.
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 28 | |
| 23 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 49 | |
| 47 | |
| 41 | |
| 21 | |
| 19 |