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
I have the data as below: I would like to have an output as below: I can use VBA to solve this, but Appreciate to any suggestion solve by Power Query. Could y
I have some data about projects I would like to transform in a way that makes it easier to analyse with PowerBi. The data looks like this: Project Number Proje
How can one collapse multiple rows of data such that it matches with its unique id. The data set is dynamically loaded from web. It is sorted by date so that ea
Is it possible for the new function UNIQUE to be used across various columns & have the output spill into a single column? Desired output is UNIQUE values
I have this statement and according to all I've seen there shouldn't be a comma anywhere in the statement but for some reason I keep getting Token Comma Expecte
I concatenated four columns using this code (to prevent null values to be linked together) in Power Query (Power BI Desktop): = Text.Combine(List.Select( { [Col
I'm trying to parse a json file but the file is set up in a strange way that excel is having problems deciphering. Please see code example below. "in_network":
I have two tables. One with dates of tech support given, and the other one with surveys sent to the customers. The problem is that the surveys are sent some day
Problem I've been tasked to tidy up some very messy data containing a mix of text and numbers and wish to use power query to separate codes from the data. Fortu
This question will seek multiple approaches LET/LAMBDA VBA UDF and Power Query Function, so there will be no single right answer, but a solicitation of approach
My data lives in Salesforce objects and I am trying to connect Power Query to Salesforce Objects. The limitation here is that I have to extract the whole object