How to do unpivot multiple columns?
Type1:
Input Table
OUTPUT FORMAT
STEP1
select the columns the columns which is constant in a table. Then select unpivot other columns
STEP2
Then split the value by the number of characters so Quater and target seperated
STEP3
STEP4
Then Pivot the Attribute column2 based on the value column to get results
To download pbix files click me
Type1:
Input Table
OUTPUT FORMAT
STEP1
select the columns the columns which is constant in a table. Then select unpivot other columns
Then split the value by the number of characters so Quater and target seperated
Then Pivot the Attribute column2 based on the value column to get results
To download pbix files click me
No comments:
Post a Comment