Capture data from different weeks and compare them

[Anonymous]

Hi i'm new to Power BI. 

I want to capture data from different weeks and compare them using a graph/chart (line graph probably).

How to do this in power BI?

Example given below:

Table 1 (captured data from week 1), i have 4 activities with different people responsible.

Table 2 (captured data from week 2), activity 3 was finished and another 3 activities were added.

Table 3 (captured data from week 3), activities 1 and 2 were finished and another 3 line entries were added.

I'd like to graph the total activities per person and track their performance per week.

I actually have a lot of other columns in my data table. But i think if this is solved i could just apply it to the whole data.

Please comment if my request is too vague so i could clarify and explain more my query.

Thank you!!

[amitchandak · Accepted solution]

@Anonymous , One of the ways is that you add the week column in each of these tables in power query and append them

Week = "Week 1"  // In table 1, in other add week 2 , week 3

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Another way to add week column and create the common dimensions of week, person and activity and  join with all three tables and use using common dimensions

[Anonymous]

It worked! Just had a small bump in adding another column and editing the values but i was able to get it with a quick search and try. Thanks for the help!