Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
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
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |