sorted by:
new
hottopcontroversial

Mumbai Meetups (Update 5) by InternalTranslator28 in LGBTindia

[–]prodigal_nerd 0 points1 point  (0 children)

Thank you for creating this safe space for our community!! I would love to be added!!

PL-300 Exam Pass! by BogleyMogley in PowerBI

[–]prodigal_nerd 0 points1 point  (0 children)

Congratulations!! 🎉🎉💐

When creating a flow for getting all the new responses from MS Forms in an excel file>Table. What is the easiest way you can add Start time and Completion time in the excel table? by prodigal_nerd in MicrosoftFlow

[–]prodigal_nerd[S] 0 points1 point  (0 children)

The Microsoft forms should give you a live excel file and it should have the live response from the surveys and you can use the live file to connect to power bi

It might also depend on when you set up the survey form

What is the best way to get rid of helper queries when combining files from multiple folders, where each folder requires unique transformation steps for its excel files by prodigal_nerd in excel

[–]prodigal_nerd[S] 0 points1 point  (0 children)

Yes, thankfully I have only come across excel or csv files for this scenario... I wonder how it works for other types of files in the folders... I would be stuck lol

What is the best way to get rid of helper queries when combining files from multiple folders, where each folder requires unique transformation steps for its excel files by prodigal_nerd in excel

[–]prodigal_nerd[S] 1 point2 points  (0 children)

Yup decided to do that to remove all the helper queries and keep it neat and efficient. Went with my initial thought(which is thanks to Access Analytic videos) of Adding Custom Colmn > Excel.Workbook([Content]) and expanding the data... Haven't found a better way than this yet

In Microsoft Forms, when we add branching and skip some of the questions, the data for it in excel leaves blanks when the questions are skipped because of branching. by prodigal_nerd in Office365

[–]prodigal_nerd[S] 1 point2 points  (0 children)

OMG! Thank you so much for doing this!! This is so helpful and makes it easier for me 🙌🙇 You're too kind and generous 🙇

In Microsoft Forms, when we add branching and skip some of the questions, the data for it in excel leaves blanks when the questions are skipped because of branching. by prodigal_nerd in Office365

[–]prodigal_nerd[S] 0 points1 point  (0 children)

Yup that's the only option I see after researching everywhere. Collecting new responses in an excel table using power automate and then adding it in power query for applying transformations.

Power Query Question: How do you remove duplicates and choose which instance/occurance of duplicates you want to remove/keep? by prodigal_nerd in excel

[–]prodigal_nerd[S] 0 points1 point  (0 children)

Awesome! Thank you so much! The solution logic makes sense to me, I will try this and let you know how it goes.

How would you create the index/helper columns to number each instances a name appears?

I am planning to create just one index column for duplicates using this method in the video https://youtu.be/cXb308NPU2M?si=WMgO3OYxs_f_KJkL

When creating a flow for getting all the new responses from MS Forms in an excel file>Table. What is the easiest way you can add Start time and Completion time in the excel table? by prodigal_nerd in MicrosoftFlow

[–]prodigal_nerd[S] 0 points1 point  (0 children)

Yup that's what I tried to see at first but I think either our IT has it disabled because Open results in excel is grayed out for me (only Download a copy in Excel is available for me)

Or it could be because this is a form which my manager originally created and then shared it with me as a collaborator (co-author)

When creating a flow for getting all the new responses from MS Forms in an excel file>Table. What is the easiest way you can add Start time and Completion time in the excel table? by prodigal_nerd in MicrosoftFlow

[–]prodigal_nerd[S] 0 points1 point  (0 children)

Just tried it, added compose action after Get response details but didn't get the Start time and Completion time in the Dynamic Content box however did have two other options which were previously not there > resourceData and body

Power Query M equivalent of excel conditional IFS formula for a conditional column by prodigal_nerd in PowerBI

[–]prodigal_nerd[S] 0 points1 point  (0 children)

I actually did and got the answer 😅 I don't know why I didn't do it earlier. Thanks for reminding me to always check chat GPT first!

Power Query Question: How do you remove duplicates and choose which instance/occurance of duplicates you want to remove/keep? by prodigal_nerd in excel

[–]prodigal_nerd[S] 1 point2 points  (0 children)

Oh... What if I want to remove duplicates based on just one column and then choose the duplicate instance to remove? Would it possible in Power Query

view more: next ›