Last seen: Aug 2, 2025
Thanks, Peter. I should have got you to tech check the file rather than the person who I got to do it!
Oops, good catch. Thanks for letting me know. Fixed now.
Glad you found it, Nate. It looks like you're still using the old interface. In the videos I have enabled the On-object interactions (File > Opt...
Hi Geoff, I would add the fiscal periods to the existing date table. Then you will have to replace the dates used in the PivotTables to the fiscal ...
Hi Robb, It's still in beta and when it becomes generally available we expect it will have an additional cost, but don't have details on it yet. ...
Great to hear, Robb. Rolling averages are more complex than they appear. This article explains them for monthly rolling averages, but you can adapt it...
Hi Nate, As Catalin explained, this is by design. To fix this you would have to merge the Invoice Line Amount and Bill Line Amount columns togethe...
Great to see you're practicing, Donald, and even more importantly, overcoming issues on your own along the way. This experience will be invaluable. ...
Hi Nate, I wonder if you're clicking on a different 'Admin'. The admin settings I'm referring to are accessed in the Power BI service. Click the co...
Absolutely correct, Peter. Good catch! I'll fix that up. Thanks for letting me know. Mynda
XLOOKUP will work with both table names and defined names. I suspect there was something wrong with the name if it didn't work. It's probably best...
Hi Peter, The third argument of VLOOKUP should be a number i.e. the column number in the range B37:E41. Your formula should translate to this: ...
The main advantage is formulas update immediately, whereas PivotTables require you to click the Refresh button or right-click > Refresh.
Hi Peter, Great to see you're practicing! First, you wouldn't be presented with a question like that in the MO-211 exam. This is quite an advanced ...
Hi Tracy, If you changed the 'Days for Completion' to only include for workdays, then you could use the WORKDAY function the way it was designed. i...