Selected year must display the sum of selected year value plus previous year value

[Ram_Yerramilli]

Hi Community, 

I need your help in creating a measure for the below requirement. My data is like below. 

For FY 20, in the Count of Current Environment, it must display the count of the previous year FY19 plus the count of FY 20 (5+42=47), and similarly for the rest of the years. Here is the expected outcome:

PROD Fiscal Year	Count of Current Environment
FY19	5
FY20	47
FY21	110
FY22	168
FY23	195
FY24	199

Please assist. I appreciate your responses. Thank you.

[amitchandak]

@Ram_Yerramilli , if you have a date table, from where this FY is coming. Or use a date table joined with date of your table with FY, Year, Month etc

Create a measure like

Rolling 2 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-2,Year))

Rolling 2 = CALCULATE([Net], WINDOW(-1,REL, 0, REL, ADDCOLUMNS(ALLSELECTED('Date'[Month Year],'Date'[Month Year Sort] ),ORDERBY([Month Year Sort],asc)))

Rolling Months Formula: https://youtu.be/GS5O4G81fww

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.