I know that there are various questions related to looking up values in power bi. However, my question is related to looking up multiple values based on conditi
I'm attempting to calculate market share (percentage of total) for a segment after a user selects a specific product within a filter. Data looks like this: Dat
I have a Power query that finds and replaces values listed in a table that I work through from here Bulk Find And Replace In Power Query But I need to apply it
I have a table that lists a series of dates and a sales amount made on each date. So against each date, I would like to create two additional columns a)A curren
I got an excel file which should use a query from an ms access file (which is a front end for a ms sql server) But instead of receiving every entry I want to us
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