Last seen: Aug 27, 2025
I looked at your query and it seems that you are creating new columns "Level1", "Level2" etc based on the 'Stufe' columns where you replaced "X" with ...
That's odd. Since Column E in the 2023 tab is formatted as Number, then loading the table from PQ where the Plot column data type is 'Whole Number' sh...
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...