DAX pivoting table

[adim]

Hi there,

I have this table in my model: 

provider_id	year	time	sample	rate
id1	2011	1	2	3
id2	2011	4	5	6
id3	2011	7	8	9
id1	2012	11	12	13
id2	2012	14	15	16
id3	2012	17	18	19
id1	2013	21	22	23
id2	2013	24	25	26
id3	2013	27	28	29

and I need to get this result table:

		2011			2012			2013
provider_id	time	sample	rate	time	sample	rate	time	sample	rate
id1	1	2	3	11	12	13	21	22	23
id2	4	5	6	14	15	16	24	25	26
id3	7	8	9	17	18	19	27	28	29

Is there any chance to achieve this through DAX? 

Thank you for your time.

Adrian

[v-shex-msft · Accepted solution]

Hi @adim,

Nope, dax is impossible to achieve this.
In my opinion, you can use original table column to create matrix visual with same result.

Regards,

Xiaoxin Sheng

[BG123]

Visual is fine but need this as intermediate table for calculations...(also unlock dynamic column selection!).

Why is this so hard? I am trying to get away from excel but some things like this are a huge nuisance to quick transfer of existing reports.