Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
snehar
Frequent Visitor

how to get future weeks value

hi friends, 
I want to get planned value for future weeks.
I have planned value table with all data(week and corresponding PV value for each project also for future week)
and also I have project table with data of each project and earned value of each week,(which has data upto current week)
also I have calender table . both table is connected to week num of calender. but when I add all data to visual it only shows upto current week and not future weeks of pv.
how to solve this. Any help would be appreciated:)

3 REPLIES 3
snehar
Frequent Visitor

in project table the date is upto current week and from that date week and year is calculated and connected with calender week and year
is this wrong and is that the reason why its getting restricted to current week or my mapping is wrong?

Ashish_Mathur
Super User
Super User

Hi,

Share some data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

snehar_0-1691663390318.png

how to get for future week like202338 or 202348

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.