My questions in Microsoft Forms
Columns for all questions
Track Microsoft Forms responses
Select your form
Select your destination file
Select your table
Map dynamic fields to correct column
Test Successful!
Result in Excel
Copy Path
Click OK and the error will disappear
For the Interest column, I’m going to create a dimension with the unique options, and a hidden table with the CombKey and the interests.
Split column into rows
Interests Combkey Table
Interests dimension
Relationship between Interests and Response
In 5 responses, 3 people found Azure interesting
Select the newly named column and select unpivot Columns
Unpivot table, renamed and added Order for Answer columns.
LikertQuestion[Question], Combkey_Likert[Answer], [# Response]
Three questions, only two numbers




Enthousiastic Power BI'er

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Building and Understanding a Classification Model for Customer Loan Approval thru PyCaret

Attorney in Utah

attorney in utah

Data Science and Competitive Programming

Statistical analysis of AirBNB data

Sparkify — Churn Prediction in a Music App using Pyspark

Temporal Knowledge Graph Embedding Model based on Additive Time Series Decomposition

Is GIS at an inflection point?

What is Big Data? Characteristics, Tools, Types, Internet of Things (IOT)

What is big data?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Erik Hamoen

Erik Hamoen

Enthousiastic Power BI'er

More from Medium

Using SQL to Organize Spreadsheet for JotForm Autofill documents

What is Performance Analyzer in PowerBI?

Split column and Combine Columns

How to Perform the Excel SUMPRODUCT Function in Power BI using DAX Query