Forum Discussion
Responsive ResidentHow to create new table that transposes original table, without using Transpose in Query Editor?
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.
3 Replies
- Greg_Deckler
Community Champion
SevsBoGreg_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!