Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.