Forum Discussion
Maria9292
Helper II
Helper IIMatrix/Table from an unusual dataset
Hi everyone! I have a dataset like this: Basically in every row No 1 has got value in column "status 1", No 2 has got value in a colum "Status 2" etc. I am trying to figure out how to ...
you can try to create a new table
Table 2 = VAR t1=SELECTCOLUMNS('Table',"No",'Table'[No1],"Status",'Table'[status1]) VAR t2=SELECTCOLUMNS('Table',"No",'Table'[No2],"Status",'Table'[status2]) VAR t3=SELECTCOLUMNS('Table',"No",'Table'[No3],"Status",'Table'[status3]) RETURN UNION(t1,t2,t3)
ryan_mayu
Super User
Super Useryou can try to create a new table
Table 2 =
VAR t1=SELECTCOLUMNS('Table',"No",'Table'[No1],"Status",'Table'[status1])
VAR t2=SELECTCOLUMNS('Table',"No",'Table'[No2],"Status",'Table'[status2])
VAR t3=SELECTCOLUMNS('Table',"No",'Table'[No3],"Status",'Table'[status3])
RETURN UNION(t1,t2,t3)