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

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

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors