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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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