Forum Discussion
Anonymous
7 years agoNot applicable
Unpivoting regular column,calculated column and calculated measure in one table
Hello All,
I have a set of data as below:-
I do some calculations over this and end up with below set of data :-
Where in OVRCOUNT1,OVRCOUNT2,OVRGOOD1,OVRGOOD2 are all calculated columns.
Furthermore I create calculated measure as below:-
Where in COUNTPCT and GOODPCT are calculated measure.
I want to unpivot all these fields into one :-
I know this is a kind of unpivoting work but I am not sure how it can be done among regular columns, calculated columns and calculated measure altogether.
Can someone help me with this, it would be a great help to me!
Thank You in Advance!
1 Reply
- v-chuncz-msft
Community Support