Charity Data Geek

Power BI, Power Query, Campaigns, Stats, Data Visualization, Raiser's Edge, Excel, GDPR and Data Protection. What could possibly be more fun?

Friday, 28 October 2022

Add extra rows in Power Query dependent on value in cell/column

›
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...
Thursday, 20 October 2022

How do you sum a total for a column in Power Query?

›
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...
Friday, 26 August 2022

Directives vs Commands in AHK/AutoHotKey

›
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...
Saturday, 20 August 2022

iPad Native Keyboard Shortcuts

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

How to get an editable list of all the files in a folder from Windows Explorer

›
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...
Friday, 1 July 2022

How to Differentiate Between Similar Field Entries

›
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...
Wednesday, 25 May 2022

Joining/Merging Columns in a single step

›
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...

Remove/Replacing part of a string in Power Query

›
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...
Friday, 1 April 2022

Regex Differs Between Google Analytics and Google Search Console

›
If you're working with both Google Analytics and Google Search Console you've probably tried at some stage to get your head around r...
Friday, 1 November 2019

Replace markers with a style

›
There's a useful blog post here  on how to convert text formatted in a certain way in MS Word with something else. What it doesn't d...
1 comment:
‹
›
Home
View web version

Contributors

  • GoatShipMate
  • Matt Page
Powered by Blogger.