custom column

I am making a Power BI dashboard and the data refresh of the power query has become unreasonably slow. The Source files are just 4 txt files (stored locally and less than 5MB total) which combined are less than 17k rows, so not large enough to cause major issues. The refresh was ok before, even...

Hi I have a parameters PQ function which is used to dynamically renames column, which is working great, however I am having trouble using the parameter in a custom column formula to reference the column name, my objective is to create the custom column so i can use to filter unwanted records...

I am having a column RawData and want to create another column Results containing a specific data from RawData RawDate Result C/O Paris Based on Sales Order 235987 AR Invoice 25634 Based on Sales Order 235987 AR Invoice 2593 Based on Sales Order 235988 New York and - Holldand Based on...

I have a file that contains transactions that are broken down into credits and debits. The issue I have is that the debits are not presented as negative numbers. I tried to create a custom column that stated if the transaction type = Debit than multiply it by -1 else keep the original amount...

Hi, I’ve been trying to make a power query to merge two tables and keep them updated with new inputs every month. Hope that its not too confusing. The idea is as follow: 1. Two separate tables, with one common column (EAN number), is imported into to individual queries by adding a custom...