Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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 |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
118 | |
79 | |
47 | |
45 | |
32 |
User | Count |
---|---|
172 | |
90 | |
66 | |
46 | |
45 |