Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

What steps to transform data for visualization?

I have a survey of 5 students answering the same question about 100 quiz questions and an auditor that also answers the questions for a sample of the questions.  See sample of data below:   sour...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

Please download the demo from the attachment. You can click the steps to see details if there are some.

if Text.Start([Attribute], 7) = "Auditor" then "Auditor" 
else if Text.Start([Attribute], 7) = "Student" then [Value] 
else let index = [Index] in Table.Max(Table.SelectRows(#"Added Index", each [Index] < index and Text.Start([Attribute], 7) = "Student"), "Index")[Value]

What-steps-to-transform-data-for-visualization

What-steps-to-transform-data-for-visualization2

 

 

Best Regards,