cumulative, Month, budget and Forecast

[Alberto95]

Hi to everyone, 

i need a huge help about this budget project, i have to show 4 columns in a matrix or table:

the budget is for month not for project. 

1. amount for selected month on page filter

2. cumulative amount until selected month on page filter

3. cumulative amount until selected month on page filter (column 2) + bdg for the remaining months (forecast)

4. Total cumulative amount previous year

here the structure of the dwh:

productions table

sku	date	id project	qty	price	total
AB-0001	01/01/2022	2200001	10	5	50
AB-0015	01/02/2022	2200001	9	2.36	21,24
AB-0052	14/06/2022	2200015	100	1,5	150
AB-0021	21/11/2022	2200018	58	0,55	31,90

sales table 

sku	date	id project	qty	price	total
AS-0001	01/05/2022	2200007	10	5	50
AC-0015	01/07/2022	2200011	9	2.36	21,24
WW-0052	14/10/2022	2200088	100	1,5	150
ER-0021	21/12/2022	2100045	58	0,55	31,90

production bdg ( for each months) table 

date	year	total qty
january	2022	3500
february	2022	4500
march	2022	5000
...
january	2023	5000

sales bdg ( for each months) table 

date	year	total qty
january	2022	8000
february	2022	7500
march	2022	6400
...
january	2023	8100

what i expect:

	month (selected)	cumlative	cumulative + forecasat	previus year
production	4350	8750	92750	94500
sales	4435	8560	90250	96500

thanks in advance to everyone. 

best regards

[amitchandak]

@Alberto95 , with help from a date table

Month

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

this month = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))

Cumulative sales

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc