Table Integration

[ericjo]

As shown in the image below, we have created two tables that are centered on the customer type and the first and second half of the previous year/the entire year as follows.

(Row : Customer type in customer table / Column : Date type in date table / Value: 1 Measure)

This is how it is expressed in power bi, but I want to make it as below.

Is there a way to make these two tables into one table as shown in the image below?

[HiraNegi]

Hi @ericjo ,

You can achieve this by appending (union) your two tables into one table, and create a custom column to identify the measure.

This will allow you to have both measures coming from same field differentiated a 'Purchase User' or  'Purache Amount' by the custom column.

You can then two field in the matrix column and acheive the desired output.

Below is the sample matrix view with 2 field in columns.

Let me know if this makes sense for your expected result.

Regards,

Hira Negi

[ericjo]

Hi, Thank u for answer.
The format like the image is correct, but if two additional values are added to the value, it seems that the value is divided about the axis as shown above.

[HiraNegi]

Hi @ericjo ,

Yes, if you add two field to the Values then you will get the values get divided on the column field.

That is why you need to bring in both the measures under one field by append/union of both tables.

If this is not clear, you can share a small sample of both base tables and I can share an example to explain further.

Thanks.