Forum Discussion

tahechadv_2022's avatar
tahechadv_2022
Icon for Helper II rankHelper II
2 years ago
Solved

Display a measure in the future

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)

data protection
Need Help
Show and Tell
Tips and Tricks
  • freginier's avatar
    freginier
    2 years ago

    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 

1 Reply

  • freginier's avatar
    freginier
    Icon for Solution Sage rankSolution Sage
    2 years ago

    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