Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sum values on same date (different tables)

Hi everyone,    I would like to ask you something. Can someone help me out.  I made those two graphics using different tables.      I would like to sum the values of the same date. So for...
  • rbriga's avatar
    rbriga
    4 years ago

    jppv20 is right. 

    If you have a calendar table that each of these fact tables can connect to (best practice),

    a measure such as Total = SUM('TableA'[Sales]) + SUM('TableB'[Sales])

    will work perfectly, assuming your visual uses the year\ month\ dates from the calendar table.

jppv20's avatar
jppv20
Solution Sage
4 years ago

Hi Anonymous ,

 

Do you have a date table to connect both tables?

 

rbriga's avatar
rbriga
Impactful Individual
4 years ago

jppv20 is right. 

If you have a calendar table that each of these fact tables can connect to (best practice),

a measure such as Total = SUM('TableA'[Sales]) + SUM('TableB'[Sales])

will work perfectly, assuming your visual uses the year\ month\ dates from the calendar table.