Home

Excel data format for Power BI

%3CLINGO-SUB%20id%3D%22lingo-sub-467080%22%20slang%3D%22en-US%22%3EExcel%20data%20format%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-467080%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attachment%20for%20data.%20I%20am%20looking%20to%20organize%20the%20data%20to%20fit%20into%20Power%20BI%20(my%20first%20project).%20The%20data%20comes%20from%20a%20paper%20survey%20that%20is%20being%20manually%20entered%20into%20Excel.%20The%20auditor%20has%20to%20survey%20food%20delivery%20bins%20to%20ensure%20that%20they%20comply%20with%20the%205%20questions%20being%20asked.%20(Y)%20for%20yes%20they%20meet%2C%20(N)%20for%20no%20they%20do%20not%20meet.%20How%20can%20I%20calculate%20the%20Ys%20and%20Ns%20to%20show%20a%20graphical%20presentation%20of%20the%20data%3F%20Do%20I%20need%20to%20reformat%20the%20data%3F%20Any%20help%20would%20be%20appreciated%20and%20thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-467080%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Jim4maticsRN
Occasional Visitor

Greetings All,

 

See attachment for data. I am looking to organize the data to fit into Power BI (my first project). The data comes from a paper survey that is being manually entered into Excel. The auditor has to survey food delivery bins to ensure that they comply with the 5 questions being asked. (Y) for yes they meet, (N) for no they do not meet. How can I calculate the Ys and Ns to show a graphical presentation of the data? Do I need to reformat the data? Any help would be appreciated and thanks in advance.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies