merge long and wide tables

[gusdcruz]

Ok boys and girls,

I am stuck (as usual...). here is the overall goal that I am trying to achieve. I want users to compare their inputed values to a standard table.

I have a standard table that contains values that will never change, in this table I have 3 different "programs" traditional, performance and growth, for each of these programs I have the estimated gorwth of an animal at certain life stages

I am using Power Apps for the users to populated their values which will go to SharePoint which is been imported into PowerBI. here is an example of the input table from sharepoint list

I would like to compare the growth of this animal from Juju's dairy to the starndard table above for each of the Life Stage, so match ADG bith to 8 from the input table to the Birth to 8 weeks from the standard table.

How do I do this?

I am also open for suggestions on how to implement this process, since I am not sure I have the best solution to achieve my goal.

thank you for your time in advance.

Gustavo

[v-lili6-msft · Accepted solution]

hi, @gusdcruz 

For your raw data structures, it couldn't be merged. Since there is no match column between two tables.

For example: why ADG bith to 8 column from the input table could match with the Birth to 8 weeks from the standard table.

So you need to adjust your data structures to keep them have the matching column as below:

For input table, it should like this:

For standard table, it should like this:

Then Merge them as below:

Now, expand the column and compare them.

And here is a demo file, please try it.

Best Regards,

Lin