Forum Discussion
Solved
Excluding data from one table and adding from another
Hi all, I have this sales table that have many outlets, which one of them is our online store. However, for online store this table isn't particularly accurate. So we have this another sales tabl...
Velvetine , You need to have common outlet and date table for that and join with both tabels and then try like
outlet = distinct(union(distinct(Table1[outlet ]),distinct(Table2[outlet ])))
CALCULATE(SUM(Table A[Sales]), FILTER(Outlet, Outlet[Outlet]<>"Online Store")) + CALCULATE(SUM(Table B[Sales]))
amitchandak
Super User
Super UserVelvetine , You need to have common outlet and date table for that and join with both tabels and then try like
outlet = distinct(union(distinct(Table1[outlet ]),distinct(Table2[outlet ])))
CALCULATE(SUM(Table A[Sales]), FILTER(Outlet, Outlet[Outlet]<>"Online Store")) + CALCULATE(SUM(Table B[Sales]))