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
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies