how to add values from two different tables in one

[ROG]

Hey guys,

I have two tables where the metrics below Chat and Calls come from the same table and CRM comes from another table.

But I need them to be displayed like the last screenshot.

Is that possible?

Currently issue

Desireble outcome

Thanks!

[Anonymous]

Hi, @ROG 

Thanks for @AliceW help. You can refer to his reply, if it does not work, you can provide the pbix file test for no sensitive data, and there is no relevant data structure in your current screenshot.

Best Regards,
Yang
Community Support Team

[AliceW]

I'd say you create a Date table. Say, 

Calendar Dates = CALENDAR(DATE(2018,01,01), DATE(2029,12,31))

Connect it with the Date field to both tables.

Use the Date field from the Date table in the resulting table. 

Boom, done 🙂

[ROG]

Hi Alice, thanks for your repky. They're already connected to a dte table. I have appended each table and I was able to get the result I want.