Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.