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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

jppv20 

 

Hi, 

I just create a date table and joined both tables with this table. It worked! So now it is possible to but them both in the visual. 

 

I am wondering if I can also use DAX to make a measure. So I will not see dark blue and light blue, but just one. 

I know I can manipulate this as wel with 'Formatting', but I would like to do this on a correct way. 

 

Thanks in advance!

rbriga's avatar
rbriga
Impactful Individual
4 years ago

You can always create a measure that does that!

Aggregate =  SUM('TableA'[Sales]) + SUM('TableB'[Sales])

 

There you have it- a measure with one number to rule them all.