How to create new table that transposes original table, without using Transpose in Query Editor?

[SevsBo]

As per the title, I have a requirement to transpose the data from the original source table.

I know one option is to use the query editor to do so, but that would transpose the original data, which I am using for one visual in PowerBi. So ideally I would like to duplicate that first data set in PowerBi and that transpose the second one only, so I can add relevant visuals based on the transposed data next to the original visual.

[Greg_Deckler · Accepted solution]

@SevsBo I created a DAX transpose: TRANSPOSE - Microsoft Power BI Community

It's not pretty.

[SevsBo]

@Greg_Deckler thanks for that, I will bookmark it if I need it, but I think I might just transpose the data in the original source as that seems to be more straightforward.

[Greg_Deckler]

@SevsBo Yes, I would whole heartedly agree! I like to try things with DAX just to see if I can do it but it doesn't mean you should be doing it that way!