Forum Discussion
vibhoryadav23
Helper II
Helper IICreate new table by transposing/Crosstab a data table
Hi, I need to crosstab/transpose data from one table to create a new table as shown in example below. Original Table: User Week Status A1 Week1 Active A1 Week2 ...
In matrix viusal , Week on column , Max of Status measure as value
Or if need a new table, Unpivot in Power Query- Take max of status -> If it does not give Option, After table is created you will see List.Count in script(formula), Make that List.Max
vibhoryadav23Helper II
Helper IIHi amitchandak ,
Thanks for your response. The second option works but it changes my current data. Is it possible to create a new table instead of changing the existing table?
amitchandak
Super User
Super Uservibhoryadav23 , Right click on table in power query and duplicate. Or Copy paste , then unpivot