Forum Discussion

Rhndy's avatar
Rhndy
Frequent Visitor
8 years ago
Solved

Need help calculating from three tables

  Hi guys,   I'm sorry for the somewhat strange title. I don't know how to call the issue that i have. Let me explain, i have 3 tables which look like this: Table 1 - M Columns: Date/time of c...
  • Washivale's avatar
    Washivale
    8 years ago

    Hi,

    Create a column in Table M and A as follow:

     

    Month Name = FORMAT([Date/Time of Creation], "MMM") & " " & Year([Date/Time of Creation])

     

    to ensure you have similar formats for Month in all three tables

     

    then create a relationship between all three tables using Month column.

     

    once you created relationship you should create following measure

     

    Records/Employees = Divide((Count('table 1'[Record Number])+Count('table 2'[Record Number])),Sum('table 3'[Number of employees],0)

     

    let me know if it works.

     

    Thank you

Washivale's avatar
Washivale
Resolver V
8 years ago

Hi,

Create a column in Table M and A as follow:

 

Month Name = FORMAT([Date/Time of Creation], "MMM") & " " & Year([Date/Time of Creation])

 

to ensure you have similar formats for Month in all three tables

 

then create a relationship between all three tables using Month column.

 

once you created relationship you should create following measure

 

Records/Employees = Divide((Count('table 1'[Record Number])+Count('table 2'[Record Number])),Sum('table 3'[Number of employees],0)

 

let me know if it works.

 

Thank you

Rhndy's avatar
Rhndy
Frequent Visitor
8 years ago

Hi,

 

Thanks for your help. it works!

You are a hero :)