I have below a list of data(Sample data) in a single column in multiple rows in excel. I would like to categorize data into multiple columns like Type, Amount,
I am trying to run a function that returns a table with a corresponding date index and date text. This is so that I can display the information in a tutorial sc
I'd like to create an Excel sheet, where in one column there is a link to a website like this: Link in column A where there is a MAC add in that url that chang
I have order table like CustomerId OrderAmount Orderdatetime OrderAmountCurrency AAA 120 02/03/2022 02:03 US$120 AAA 20 02/03/2022 02:20 US$20 AAA 320
In Excel I am trying to call an API for a list of IDs. The list of ids are stored as a Table in Power Query: ID 00001 00002 00003 I want to call an API: S
I have one query can somebody please tell how to show Latest date in a date format So basically, I want to show the latest date selected by default and if the u
I have two tables, Table A contains an attribute (ID1) and Time (date/time format). Table B contains an attribute (ID2) and two time columns Time_start and Time
I am using Excel 365. I have a Power Query (PQ) that reads off a MS SQL database and I need to set parameters for that query from a table in the same Excel work
I have Employees and their Overtime hours. There is a cap of 5 hours Max overtime per week, and on basis of that, I submit data to payroll team. However, I am n
I have a range named tDetails. How can I query this using SQL? I click in my range, and on the Power Query tab, I click "From Table/Range". This opens the Power
I am transforming some data from a database, and at the end of one of the step, I need to reformat it for sending it as a document to a client. the usual templa
I am struggling with transforming xml message to table view. Was searching for it, found few solutions, none of those worked or I implemented those poorly. Kind
I install SQL Server Connector for Power Query for SQL server 2017. Create SSDT SSIS package with power query connector. It works perfect in SSDT! But when I de
I have views that my users often only need to check for one particular person at a time. To do this, they do the following in Excel 365 desktop: Open a blank wo
Table 1: Table 2: Result: I have tried using Fuzzy matching but it's not giving me the results. Please help!
I have a call dataset. Looks like this If a call about a certain member comes in within 30 days of an "original call", that call is considered a callback. I ne
I have 2 tables: google_analytics and marketing_costs. How can I join these 2 columns (google_analytics['source'] with marketing['medium']) even tho they don't
Quick Note, I have reviewed these threads and they do not fix my issue: ( Outdated info, see documentation below ) Access Snowflake query results through PowerB
I wish to generate the Most common, Highest and Lowest values from the following data: I have also added an additional column to handle text comments. M Code s
please dont hurt me for this question... I know it is not the ideal way to handle mass data- but I need to try... I got a folder with 10 csv Files which are alw