Creating 2 levels of tables to get your answers

[hdhillon]

All,

I have a data model of 4 tables all linked with relationships

I want to summarise things from the data model, do I can then create a visual bar chart from it

Step 1:  I want to create a bespoke table with various columns from each of the tables.

Step 2:  I want to create a summarize this table (do various group bys, counts, sums etc)

(INFO ONLY )  Step 3: Turn this into a visual 

How do I do Steps 1 and 2 ?

[hdhillon · Accepted solution]

All,

I managed to solve it using the power of Google.  

1.  Created a table with Selected Columns Function

2.  Then created another table from the top one and used Summarize function to create a aggregrated table from it

[lbendlin]

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523