is it possible to compare particular values from a table/report from power bi data set with another table from excel sheet? In the power bi data set i have the
I hope to get a solution here. I am completely new to R and really all i need it for is to extract data from power query and append it to an existing csv file.
I have dates like: I need to do two transformations: Convert it into datetime field date and time in the initial data shows in GMT. Necessary translate into ou
I have three Worksheets in a Excel Workbook 1-sht_Customers 2-sht_Quotes 3-sht_Contacts Each of the Worksheets contain one table each. 1-tbl_Customers 2-tbl_Quo
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