Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
16 | |
14 | |
14 | |
10 |