Last seen: Jul 22, 2026
Hi Peter, The calculation in column H is me demonstrating the calculation that's taking place in the background of the Conditional Formatting rule....
Hi Peter, I can't provide the solution to this because I'm asking you to create a name and if I have already created that name, you'll get an error...
Hi Yen, Creating a Profit and Loss statement in Power BI/Power Pivot is very difficult because it's not designed to work on rows within columns. I ...
Hi Peter, Strictly speaking you are correct however, most people incorrectly think a distinct list is a unique list, so I have maintained that vern...
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...