Last seen: Jul 7, 2026
Formatting a text "1" as a number does NOT change it into a real number. Make sure that you have set the correct data type in PQ for the Plot column a...
The Plot column in Table2023 contains text that all look like the number 1. That's why the formula breaks. I notice you used Power Query to import dat...
Just drag the 'Plea' column to the Column area. I attached a very small scale example, showing what you have and what you want.
My guess would be that you can just change the last step to: Filtered Rows: = Table.SelectRows(#"Changed Type", each [NCMR Number] <> null an...
You're welcome @Saliha Thanks @Hans
I understand that you get the ageing report (columns A to O) from your ERP system. The file you uploaded is for week number 43. It's static informatio...
The attached file contains an example of a table with two columns. The first, [AE] to contain either "Asset" or "Expense". The second one is [ProductN...
The calculated field you are trying to create divides a number (PII's) by a text (Job) resulting in a #DIV0! error for all rows. If you want to stay w...
Difficult to help if you don't share a file.
My understanding is as follows, referring to the data in your latest file: 1) You have a list of products with prices as per 1 August. I call this ...
Does the Employee table have multiple rows for the same employee but working for different departments? If so, rename that table to e.g. Assignment...
The screenshot doesn't show any amount column(s) but let's assume you have one where the sign follows standard accounting principles. In the PQ edi...
'Good solution' is a big word. Since you would only do this once a year it would almost be quicker to have a list of all Friday's, mark all holidays o...
You can open the xlsb file by right-clicking and then Save link as and than point to a folder on your system. That's how I did it. Forgot to save the ...
To keep it fairly simple I would perform a few consecutive merges, comparing first all Fridays against the holidays. Then keep the date or deduct one ...