Summarize Table

[1984]

Can anyone tell me the most efficient way of creating a summary table summarising data across tables that are linked by relationship?

[1984]

@speedramps Thanks for your reply apologies for the vagueness I wasn't too sure how to ask what I'm looking for I can supply table examples tomorrow.
For now as a bit more context I have four tables linked by relationship. Table 1 has a one to many relationship to table 2, table 2 has a one to many relationship to table 3, table 3 has a one to many relationship to table 4.

The result I'm trying to achieve is a summary table that has Jan-Dec in column 1, in column two it looks up across all four table to count the rows the match it's criteria.

So for example countrows if column 2 of table 2 equals "x" "y" or "z" and column 2 of table 4 is not blank and column 3 of table 4 is the same date of that in column 1 of the summary table created.

I hope this is a bit easier to digest and kept simple I've had a long time out of this so appreciate the guidance 

[speedramps]

We want to help you but your description is too vaugue. Please write it again clearly and provide more context.

Provide example data model diagrams, input data as table text (not a screen print) so we can import the data to build a solution for you.
Also provide the example desired output, with a clear description of the process flow.
Remember not to share private data ... we don't want you to get into trouble. 😧
Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.
Try keep it simple and ask one question per ticket.
You will get a quick response if you put time, care and effort into writing clear problem descriptions.
Remember you are gerrting free expert help, so please put lots of care and effort into asking questions and providing example.

Vaugue descriptions can waste your time and ourtime.

Look foward to helping you when the above information is forthcoming

[1984]

@speedramps I have made a duplicate dummy dataset hopefully this is the missing piece to the puzzle please let me know if I have missed anything thing or there is anything more you want to know 🙂

Table 1

Let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSrQINcw3AAOvwlBfV0cDJR0lRydnQyNjpVgdFHnPEMdiV0d/oDxQEqhEKTYWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, #"UNIQUE ID" = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", type text}, {"UNIQUE ID", type text}}) in #"Changed Type"

Table 2

let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSrQINcw3AAOvwlBfV0cDJR0lIwMjA11DI2MTUzMgL9EiyMAMoiQlNdzY1dFTKVYHRadniGOxq6M/TKejk7OLqxu6zggvV8dIpdhYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"ID REF" = _t, REF = _t, ID = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"REF", type text}, {"ID", type text}}) in #"Changed Type"

Table 3

let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCnENDtE1NDI2MTVT0lFKtAgyMDMAg5TUcGNXR0+wYARU0KmsPLnM1dEJKOicn1uQk1qSmqIUqwM1xdzC0tDAkBhT/HOSXR3dgIIIzZamhoZmJibouiO8XB0jUXQ7p2Vb4nSCpYGBhZE5YUOATsitgDkhFgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [NAME = _t, JOB = _t, ID = _t, STATUS = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"NAME", type text}, {"JOB", type text}, {"ID", type text}, {"STATUS", type text}}) in #"Changed Type"

Table 4

let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSrQIMjAzAIOU1HBjV0dPJR0lL0c/XSMTpVgdHPJQmQiojHOaebalq6MTUMbN1QmhE4u8UmwsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Task = _t, DATE = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Task", type text}, {"DATE", type date}}) in #"Changed Type"

Relationships

Table 1 (ID) to Table 2 (ID Ref)

Table 2 (ID) to Table 3 (Job)

Table 3 (ID) to Table 4 (Task)