Forum Discussion
CConsultants1
3 years agoFrequent Visitor
How To Get Previous Weekly Total In Power BI Matrix Table
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 w...
amitchandak
3 years agoSuper User
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-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
- CConsultants13 years agoFrequent Visitor
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.