Last seen: Jul 6, 2025
Hello Ethel, Welcome to MOTH. How do you want it to be presented? Highlighted using conditional formatting or using some kind of report form? Anywa...
Well, I am soon out of suggestions. Do you get any alert message in the Queries and Connections view for those queries showing null values? If so, wha...
Hello, If it works fine when refreshing one query at the time then I can only assume nothing is wrong with the queries. Might be that you've got an...
Hello, Do you get null when refreshing one query at a time instead of all at the same time? Br, Anders
Hello Dan, I am not skilled enough in Power Query to look for a solution using that tool, I have instead looked into highlighting the overlapping d...
Hello, Jessica has provided a nice solution with a pretty advanced formula. Just want to share that with helper columns you can simplify the formul...
Hello, One easy way to solve this issue is to check if the filter results in an error, if so it is because it can't find any matching data to filte...
Hello, Relations in Power Pivot is not the same as relations in a relational database. I have made some adjustments, in so making Table B a fact ta...
Hello Andy, Sorry, no file is attached. While at it, please add some sample data also if it is not already existing. Br, Anders
Hello, I need a formula that compared qty within E2 and K2 So if qty of the carton is less 200 then display Q2 and R2 if 200 equal to or more tha...
Hello Dan, Sorry, no file attached. You need to click the Start Upload button after you have added the file. Br, Anders
Hello, Can you attache a file with sample data, as it is now I am just guessing how your data looks like. Br, Anders
Hello, Yes, if the data is already imported you often use the IF function in a helper column to determine what to do. It can also be handled during...
Hello Deepak, I am sorry, I am no coder. Wasn't the article I linked to of any help? Br, Anders
Hello, Create a third table containing unique batch numbers, then create relationships. Table A * —— 1 Table C Table B * —— 1 Table C Br, And...