Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
Hello, a question
I want to unpivot two groups of variables in my database.
First group: indicators
Second group: educational levels
both are dummy variables 1 and 0
My database looks like this:
id_school | ind_01 | ind_02 | ind_03 | Preschool | Elementary School | Middle school |
23 | 0 | 0 | 1 | 0 | 1 | 1 |
24 | 1 | 0 | 1 | 1 | 1 | 0 |
25 | 0 | 1 | 0 | 0 | 0 | 1 |
What do I need?
Develop segmenters by indicator and level of education.
I need this:
id_school | Indicators | Value | Education Levels | Value |
25 | ind_01 | 1 | Preeschool | 1 |
25 | ind_02 | 0 | Elementary School | 1 |
27 | ind_01 | 1 | Elementary School | 0 |
28 | ind_01 | 0 | Middle School | 1 |
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
78 | |
76 | |
70 | |
49 | |
42 |
User | Count |
---|---|
62 | |
40 | |
32 | |
30 | |
29 |