Forum Discussion

pedrocDAcamara's avatar
pedrocDAcamara
Frequent Visitor
3 years ago

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...
Need DAX Help
pedrocDAcamara's avatar
pedrocDAcamara
Frequent Visitor
3 years ago

Hi FreemanZ 
They're connected through a field called PROCESS

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      pedrocDAcamara
      Frequent Visitor
      3 years ago

      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