Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
matout
Helper I
Helper I

Connecting multiple data points

Hello,

 

I am trying to analyze a survey answers which has 800+ rows based on multiple data points, from within the some questions answers. the survey has 119 questions, each question with 5 options.

For example

 

I want to classifiy each rows as 

- Organized, semi organized, not organized.

by

Organized classification is 

Question numberOption
Question 1Option 2
Question 5

Option 3

Question 6

Option 4

Question 13

Option 5

Question 44

Option 1

 

And semi organized as for example

Question numberOption
Question 1Option 3
Question 5

Option 1

Question 6

Option 5

Question 13

Option 2

Question 44

Option 4

 

 

is this obtainable? and how 

 

thank you 

4 REPLIES 4
amitchandak
Super User
Super User

@matout , a new column like

 

new column =
Var _1 = if([Bank Account]= "Yes" ,1,0) + if(not(isblank([Accounting Practice])),1,0)+ if([Accountant]= "Yes" ,1,0) + if([External Auditor]= "Yes" ,1,0) + if([Online Banking]= "Yes" ,1,0)
return
Switch( True() ,
_1 = 5, "Organized",
_1 >0 , "Semi Organized",
"Not organized"
)

 

Change as per need

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Hello, thank you for the answer.

 

this solution is helpful, however, there are 3 different values in the "Accounting practice" column.
How can I diffrentiate them, this is not just true or false.

amitchandak
Super User
Super User

@matout ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Hello, thank you for the answer

 

I have a survey. with 119 question, each question is a column. 

each answer  for the survey is a row in the table.

 

for example

 

Company ID    Bank Account?       Accounting Practice     Accountant?      External Auditor    Online Banking?     

1                            yes           Accounting system                  Yes                         No            No          No                 

2                            No            Accounting records                 Yes                         No            No          No                 

3                            Yes          Accounting system                    Yes                        yes           Yes         No                 

 

 

I want to classify each company (row) as Organized, Semi Organized and Not organized.

based on thier answers to the questions. 

 

For example, if a company has a bank accout, Accounting practice, Accountant, Registered trade name and Tax number

 

this company will be labeled as organized. 

I have other criteria for semi organized and other for not organized

 

 

Is this obtainable and how?

Thank you

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.