Display a measure in the future

[tahechadv_2022]

Guys, I need to know if display a measure in the future is viable. Let me explain it.

I have this visual above, it shows values by date.

I have another measure that sums up the previous month. I want to sum may (maio) and display it as july.

Is it possible in Power BI? Because my dataset goes until June (junho)

[freginier · Accepted solution]

Hi @tahechadv_2022  you need to create a calendar that goes to July and then you should be able to create a mesure using for example DATEADD(<Dates>, -1, Month) to get Juin value in July