Last seen: Mar 8, 2026
Hello, If you double click the query after getting the error you should get more details of what is generating the error. Br, Anders
Hello, See if the example in column F suits your need. There is no error handling and the formula was created in tablet version of Excel, meaning i...
Hello, It is always easier if there is a sample file, I will give it a try anyway. I am replying this from my tablet, so can’t double check in Powe...
Hello, If your data is in Excel tables and you have activated the option to show the Total Row (Table Design, Table Style Options), you can referen...
Hello, Do you have a sample file to share? That would be easier for everyone as it's then not necessary to create new file with dummy data. I as...
Hello, With synced folder you still have the data available even when not online, with mapped folder you need to be online to get the data. Br, ...
Hello, Just a question, wouldn’t custom data types be a better alternative? Br, Anders
Hello, No need for Power Query for this. See attached file for one example on how this can be achieved. Just add a new column to your table where y...
Hello, There are no formulas in your file. For simplicity, do add dates with your time, then it all works fine. Br, Anders
Hello, In my point of view you need not to worry. With Excel 365 you get what Excel 2016 has and more. This support page lists all functions availa...
Hello, A sample file showing your data (not necessarily the real sales data) and what you are struggling with would be of good help here. Br, An...
Hello, I searched for the exe file and found this blog post, seems you get to live with it. Question: does it behave differently if you run the .Ba...
Hello, As you surely knows, the result all depends on what margin widths you choose, what row and column widths and heigths you have and so forth. ...
Hello, You can read more about using IF statements in Power Query here. See attached file and sheet With measure, is that something in line to w...
Hello, Ok, thanks for clarifying. In attached file I propose a different approach, it is simpler and dynamic. It requires though that you have P...