Last seen: Aug 4, 2025
Hi Ayal, Thanks for clarifying. I don't recommend links to external workbooks. Instead, use Power Query to bring the Plots List data into the Dusti...
Hi Ted, You can use the same formula, choose Wednesday from the data validation list to return the first Wednesday, and then add 14 days to take yo...
Hi Ayal, I'm not sure what you mean by 'plots', nor how your data is laid out. Can you please provide an example file that shows the data, and your...
glad I could help!
Hi Ayal, The lookup formulas are bringing data in from an external file. With Power Query you can use the Get Data > From File connector (lesson...
Hi Ayal, I happened to see a video of this by fellow Microsoft MVP, Wyn Hopkins the other day. You can watch the solution/explanation here. Mynd...
Hi Teja, Yes, VBA would be the only way to do this. There are no built-in settings for Excel to detect the size of a screen. The only other opt...
Hi Emmanuelle, Go to PivotTable Options > Layout & Format tab > For empty cells show: N/A Mynda
Hi Joachim, You can use Power Query to do this as explained here: Compare two Excel Lists with Power Query. Mynda
It'll be a floating point problem. Although what you see in the cell might be 200.000000' for example, in the actual underlying XML file it's probably...
From what I remember, the shape map charts in Power BI are fairly limited. You might be able to write a measure that filters the results displayed in ...
Hi Michelle, Great to hear you're making progress through the course. I don't cover dynamic date tables, only auto-generating date tables. Although...
Hi Brandie, Welcome to our forum! The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the g...
I'm not sure I fully understand the question, Robert. That said, my guess is no, it's not possible because the gradient is dictated by the range of va...
No, filters only work with font colour and fill colour. If you do not have access to the account group table from the original database, you can us...