Forum Discussion
Create new table by transposing/Crosstab a data table
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
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
Hi 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?
vibhoryadav23 , Right click on table in power query and duplicate. Or Copy paste , then unpivot
