Charity Data Geek

If you've ever imported data from a US supplier into a (UK) spreadsheet you may have found that the dates and times have gone wrong in E...

Back October I showed how to run a quick sum of a column in Power Query. But I curious to know how I could see this total alongside a count...

If you're working in Power Query, and you need to add a whole bunch of blank rows, or rows based on the value from another column. How d...

Power Query has a "Count Rows" button, but there's no equivalent button for when you want to quickly get the total of your val...

I couldn't find a direct answer to this question, so thought, once I'd managed to piece it together I'd post it here for any fut...

I've had an iPad for over a decade and always found it's keyboard, particularly the lack of backwards and forwards keys, frustrating...

Often you have a lot of files in a folder and for some reason you want to paste them in Word, Excel, Notepad or something else, but a straig...

Say you run a series of events and want to display registration, attendance etc on a bar chart in Power BI. The length of the event names an...

As per my previous post sometimes, for tidiness you just want to do something in a single step. So how do you do this with merging / joining...

If you like keeping things neat and understandable in Power BI then you probably like to minimise things to one line. So there are times whe...