This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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 April 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 |
|---|---|
| 32 | |
| 28 | |
| 21 | |
| 18 | |
| 17 |
| User | Count |
|---|---|
| 62 | |
| 35 | |
| 34 | |
| 24 | |
| 24 |