Multiple Tables into a Matrix

[Anonymous]

I created multiple tables which shows values for what happened yesterday and then the prior week. (See below). I was wondering if it was possible if I can create a Matrix which just has 2 columns (Yesterday and then Last Week). And then just having the 4 values in 1 matrix. Is that possible? The values are all using a created metrics I created. Or would I be able to create a summarized table to do this easily?

[MFelix · Accepted solution]

Hi @Anonymous ,

If you add the values on a matrix you are abble to show them in the same table, you can do and auxiliary table with the following format:

Then add a metric with the following code:

Matrix Measure = SWITCH(SELECTEDVALUE('Table (2)'[ID]),
1, [Accounts Created Yesterday],
2, [Signins Yesterday],
3, [Accounts Created Yesterday],
4, [Signins Last Week]
)

Result would be similar to the one below:

 or

You can then format the table has you need in order to get the better look and feel