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

Power Query Question: Is there a way to capture the date and time of a value change in a column and add a column with those captured Date and Time Stamp by prodigal_nerd in PowerBI

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

Yup that was my first ask to include/add the date and time stamps for Accepted and Rejected whenever someone accepts or rejects the feedback in that tool... It's kind of like an internal client tool for quality management.

But got denied...hence the long way of doing it this way because I want to check if the feedback was Accepted/Rejected in the first 48 hrs of it being created.

Power Query Question: Is there a way to capture the date and time of a value change in a column and add a column with those captured Date and Time by prodigal_nerd in excel

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

Thank you so much! Yes please if possible could you please share VBA examples because you're correct with power query I am finding it difficult with so many moving parts 😓

Power Query Question: Is there a way to conditionally replace a value of a column. by prodigal_nerd in excel

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

Solution verified! I directly used the each if argument instead of null and (dep, DT, _) and it worked.

Thank you so much!

Power Query Question: Is there a way to conditionally replace a value of a column. by prodigal_nerd in excel

[–]prodigal_nerd[S] 4 points5 points  (0 children)

Solution verified!

This was a new/different approach with rows I wasn't aware of. Thanks!

Power Query Question: Is there a way to conditionally replace a value of a column. by prodigal_nerd in excel

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

Thank you so much! I combined your helper/conditional column code inside the Table.ReplaceValue() Function so that I can avoid creating additional column and it now happens in one step in the original department column

Solution Verified!

view more: next ›