Forum Discussion
Total by month without date table
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
4 Replies
FreemanZSuper User
how are sales and meal tables related?
Hi FreemanZ
They're connected through a field called PROCESS- FreemanZ
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.
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
