March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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 number | Option |
Question 1 | Option 2 |
Question 5 | Option 3 |
Question 6 | Option 4 |
Question 13 | Option 5 |
Question 44 | Option 1 |
And semi organized as for example
Question number | Option |
Question 1 | Option 3 |
Question 5 | Option 1 |
Question 6 | Option 5 |
Question 13 | Option 2 |
Question 44 | Option 4 |
is this obtainable? and how
thank you
@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
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.
@matout ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
23 | |
16 | |
15 | |
7 | |
6 |
User | Count |
---|---|
33 | |
29 | |
16 | |
13 | |
12 |