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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.