https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-a-measure-in-the-future/m-p/4025666#M158923 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="441408" data-lia-user-login="tahechadv_2022" class="lia-mention lia-mention-user">tahechadv_2022</a>&nbsp; you need to create a calendar that goes to July and then you should be able to create a mesure using for example DATEADD(&lt;Dates&gt;, -1, Month) to get Juin value in July&nbsp;</P> Thu, 04 Jul 2024 19:47:10 GMT freginier 2024-07-04T19:47:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-a-measure-in-the-future/m-p/4025610#M158922 <P>Guys, I need to know if display a measure in the future is viable. Let me explain it.</P><P><img /></P><P>I have this visual above, it shows values by date.</P><P>I have another measure that sums up the previous month. I want to sum may (maio) and display it as july.</P><P><img /></P><P>Is it possible in Power BI? Because my dataset goes until June (junho)</P> Thu, 04 Jul 2024 18:47:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-a-measure-in-the-future/m-p/4025610#M158922 tahechadv_2022 2024-07-04T18:47:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-a-measure-in-the-future/m-p/4025666#M158923 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="441408" data-lia-user-login="tahechadv_2022" class="lia-mention lia-mention-user">tahechadv_2022</a>&nbsp; you need to create a calendar that goes to July and then you should be able to create a mesure using for example DATEADD(&lt;Dates&gt;, -1, Month) to get Juin value in July&nbsp;</P> Thu, 04 Jul 2024 19:47:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-a-measure-in-the-future/m-p/4025666#M158923 freginier 2024-07-04T19:47:10Z