Create Table using data in multiple columns

[Anonymous]

I am trying to make a single table in PowerBI using all the data below... any help would be appreciated

Sample data

Using the data above I can create a table for a specific column example :

What I am trying to do is make a table that would show counts from all columns, Example.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You can create a new table with UNION() and SELECTCOLUMNS() function.

Table 2 =
UNION (
    SELECTCOLUMNS ( table1, "TU", table1[T1U] ),
    SELECTCOLUMNS ( table1, "TU", table1[T2U] ),
    SELECTCOLUMNS ( table1, "TU", table1[T3U] ),
    SELECTCOLUMNS ( table1, "TU", table1[T4U] )
)

Then you can count it.

[amitchandak]

Create unpivoted table

refer : https://radacad.com/pivot-and-unpivot-with-power-bi

[Anonymous]

@amitchandak This data is coming from shairpoint and is not pivoted, I only provided a sample based off of how the true data is presented to me.   When I tried to follow those instructions everything transformed to "Error"