Forum Discussion

ninakarsa's avatar
ninakarsa
Icon for Helper II rankHelper II
6 years ago

calculating sales between dates

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 mad...
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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