Total by month without date table

[pedrocDAcamara]

Hello everyone
My sales table is connected to my DimDates and also connected to Meal Table.
This Meal table has the number of persons per table and is connected also with DimDates.
The visual that I want to do is the number of people the restaurant has by month, like, Jan, Feb, and so on.
I need a measure that sums all people by month.
Can anyone help me?
Thanks in advance

[pedrocDAcamara]

Hi @FreemanZ 
They're connected through a field called PROCESS

[FreemanZ]

hi @pedrocDAcamara 

Meal table and DimDates seem not related.

Nevertheless, which column tells the number of persons? Try to merge that column into your sales table in Power Query Editor.

Then you shall be able to summarize the number of people the restaurant has by month.

In case of further issue, please post some sample data and let us show how. 

[pedrocDAcamara]

Hello @FreemanZ and thank you for your answer.
Yes, now they're connected but it's not active which means if i want to calculate the number of people i have to do it with userelationship. But i don't think is enough. Please see this

It's important to say that every table except dates are connected in direct query.
Can you help me and try to answer both my questions above?
Thanks in advance

[FreemanZ]

hi @pedrocDAcamara 

how are sales and meal tables related?