calculating sales between dates

[ninakarsa]

Hi Members

I am new to powerbi and need a bit of help.

So I have 2 tables, table 1 has the budget which needs to be met between from date and to date by car park. Table 2, shows the sales made by date for the car park. Based on these 2 tables I need to create table 3 which shows the total sales against the budget by car park.

Table 1:

Car Park	Budget	FROM DATE	TO DATE
Area A	10,000.00	01/05/2020	31/10/2020
Area B	200,000.00	01/01/2020	31/12/2020

Table 2:

Car Park	Date	Amount
Area A	01/05/2020	1,000
Area A	10/05/2020	1,500
Area A	10/06/2020	2,000
Area A	15/06/2020	150
Area B	10/06/2020	1,000
Area B	10/07/2020	500,000
Area B	11/07/2019	60,000
Area B	05/08/2020	10,000
Area B	01/02/2020	50,000

Table 3:

Car Park	Budget	FROM DATE	TO DATE	Total
Area A	10,000.00	01/05/2020	31/10/2020	4,650
Area B	200,000.00	01/01/2020	31/12/2020	561,000

[az38]

Hi @ninakarsa 

try to add a measure in your table 1:

Total = CALCULATE(
    SUM(Table2[Amount]),
DATESBETWEEN(Table2[Date],SELECTEDVALUE(Table1[FROM DATE]),SELECTEDVALUE(Table1[TO DATE]))
)

before, be sure you have a relationships between Table1 and Table2 by [Car Park] columns

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn