Analysing variation of status through time from different tables - Line chart

  • Hello, I am having a brain freeze issue because I cannot think of a solution to the below - I am sure you guys will come up with something that will be obvious once it's explained to me lol.


    So basically I have different sources of data, all containing the same format (i.e. column names) but each source is an updated version which contain the new status of the item. For example:


    Table1

    Item0Not Verified01/07/2020
    Item1Not Verified01/07/2020
    Item2Not Verified01/07/2020
    Item3Not Verified01/07/2020
    Item4Not Verified01/07/2020


    Table2

    Item0Verified01/08/2020
    Item1Not Verified01/08/2020
    Item2Verified01/08/2020
    Item3Not Verified01/08/2020
    Item4Not Verified01/08/2020


    Table3

    Item0Verified01/09/2020
    Item1Verified01/09/2020
    Item2Verified01/09/2020
    Item3Verified01/09/2020
    Item4Verified01/09/2020


    I need to somehow get this data together (preferably using data model relationships) and come up with a line chart that would show the number of items per date per status. A bit like the example below:



    If you could explain how to join/relate the data, which fields for the chart (do we need to create helper fields?), etc... I would be very very grateful.

  • Hi all, just wanted to mark this post as finished. I think the only way of achieving what I want is by 'appending' the files - which can be achieved by using Power Query for example.


    Sorry moderators for not finding the way of closing this thread (I honestly can't find how to close it myself)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!