Last seen: Apr 22, 2025
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...
Oops! Good catch, Peter. Thanks for letting me know.
Hi Peter, That's odd. Make sure you're logged into Excel. If that doesn't help. Try the feedback button on the Help tab and send a report to Micros...
Hi Robert, What exactly were you trying to do in terms of editing? Change amounts, change formatting, something else? Mynda
Hi Robert, I think that site has changed its structure/layout, so Power Query isn't able to work with it as it did when I recorded the video. I...
Hi An, This is a setting change that you or your IT admin have to do. You can see if you have access to make the change by clicking on the cog icon...
Apologies, Bax. I haven't been clear. In Power BI you can copy and paste your data into a table. Doing this creates JSON code for your dataset in t...