Hi All, please find the example reconstructed in Excel below. The real file is 600k rows long and has ~75 "items" spread over ~35 "sets". This is my first post on the Forum, so please let me know ho...
Hey! I have a dataset listed by Date/time that shows the production runs by-product throughout a day, the catch is the same product could be made in different batch sizes at different times of the d...
I am struggling with Invoice Freight Cost allocation per Unit. My data consists of InvoiceNo, FreightAmt, ItemCode and Quantity Shipped (see table below). For example: Invoice 91 cost $23.18...
This first formula works, but I am trying to remove the hard column reference ([FY24 Original Baseline]) to a dynamic reference from a varible: List.Sum(Table.SelectRows(tbl_DSBaselines, (I...
I have two columns called "shipping_state" and "shipping_city". If shipping_state has blanks, I want Power Query to cross check what is the text value in the same row under shipping_city and...
Hi, I'm trying to add duration to start time in order to get the end time using the #duration () function, but seems it doesn't accept decimals as I understand the duration function does account the...
Greetings! I have a data set where the budget amount is stored in the first period of each year. We need a monthly budget amount for each period which can be the amount ...
Hi all, First time poster! I'd appreciate any help you can give me with this question... I need to create a dynamic matrix and line chart that shows the percentage change ...
Hello! I'm a Power Query newbie, trying to create a Measure based on the following Excel formula: =(AG8*AE8*AH8*AJ8+(AG8*AE8*AH8))*AI8+(AG8*AE8*AH8*AJ8+(AG8*AE8*AH8)) but am running i...