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...
FreemanZ
Super User
Super User
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