Last seen: Jul 3, 2025
One minor observation: End(xlup) is not 100% reliable, if for example the entire column A has a color or borders, even if cells are empty this method ...
Hi Chris, You can transform the lookup table query into a function, after adding a new column to check for a match on each row. Note that there ...
Hi Luna, See this article for a solution to fix the existing file, it might be hard to replicate your reports into a new file. I think it's easy...
rw refers to current row context. Table.AddColumn(#"Removed Columns2", "Is Single Min", (rw)=> Table.RowCount( is equal to: Table.AddColum...
The only way to get data into PBI is through power Query. PBI has power query and power pivot as modelling tools. Unlike excel version, you cannot bri...
Here is the full query then: let Source = Excel.CurrentWorkbook(){[Name="tblDay1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Sour...
There is no query in the file you provided, how can I find a reason for slow query when there is no query? As mentioned, I have to see what your qu...
Not a good idea, sounds like you need a design improvement. See this article about how to bring data from a folder with multiple files. You can com...
Trond Liavik said Therefore I don't think having all salary types in one array at same time will be a good ide. Why? It will be 1000 times faste...
It's obvious that you need a formula for that. I was talking about manual results, so we can see some example calculation results.
And where is the expected result?
Hi Mayank, You can take a look at this topic: As you can see there, it's a matter of what your query does. As I said before, trying to imitate ex...
Hi Trevor, You'll love PQ more after this 🙂 , below is the query modified. What I did to achieve the same results: After your AddedIndex ste...
Can you provide some examples? "finish if less than 17 hours before 07:00 on Saturday" sounds strange, will be easier to understand you problem if ...
You can do a transformation in that column, check if that value is a number and replace it with null, this way fill down will work in that column. ...