https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-future-weeks-value/m-p/3373966#M127022 <P>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<BR />is this wrong and is that the reason why its getting restricted to current week or my mapping is wrong?</P> Thu, 10 Aug 2023 10:34:52 GMT snehar 2023-08-10T10:34:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-future-weeks-value/m-p/3373850#M127009 <P>hi friends,&nbsp;<BR />I want to get planned value for future weeks.<BR />I have planned value table with all data(week and corresponding PV value for each project also for future week)<BR />and also I have project table with data of each project and earned value of each week,(which has data upto current week)<BR />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.<BR />how to solve this. Any help would be appreciated:)<BR /><BR /></P> Thu, 10 Aug 2023 09:23:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-future-weeks-value/m-p/3373850#M127009 snehar 2023-08-10T09:23:03Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-future-weeks-value/m-p/3373879#M127011 <P>Hi,</P> <P>Share some data and show the expected result.</P> Thu, 10 Aug 2023 09:37:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-future-weeks-value/m-p/3373879#M127011 Ashish_Mathur 2023-08-10T09:37:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-future-weeks-value/m-p/3373959#M127021 <P><img /></P><P>how to get for future week like202338 or 202348<BR /><BR /></P><P>&nbsp;</P> Thu, 10 Aug 2023 10:31:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-future-weeks-value/m-p/3373959#M127021 snehar 2023-08-10T10:31:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-future-weeks-value/m-p/3373966#M127022 <P>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<BR />is this wrong and is that the reason why its getting restricted to current week or my mapping is wrong?</P> Thu, 10 Aug 2023 10:34:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-future-weeks-value/m-p/3373966#M127022 snehar 2023-08-10T10:34:52Z