Posts


Writing a Blog Post About M Lang/M Language/Power Query Formula Language/Power BI/Get & Transform

Published on June 21, 2017 at 12:51AM

Informally Known As WTF is M

Connect PowerBI to a Remote PostgreSQL Database Encrypted with SSL

Published on June 20, 2017 at 10:55AM

You read the brochure but you just can't get that hot tub workin'

Quickly Switch Between Worksheets in Excel using Shortcut (Alt+Backtick)

Published on June 19, 2017 at 01:31AM

Copy this to your PERSONAL.XLSB to quickly switch between Worksheets on the ActiveWorkbook

Permanently Set the PostgreSQL datestyle to ISO, DMY, European or Australian

Published on June 14, 2017 at 01:14AM

I keep setting up servers with default postgresql.conf which is MDY

Center Aligned Pagination in Rails using Bootstrap 4 and Kiminari

Published on June 14, 2017 at 12:21AM

Pagination looks nice when it is centered below a table. Here is how I got it to work.

Excel Actually Sucks

Published on May 18, 2017 at 03:23AM

Just a place where I can write all the things I hate about Excel. Remember to just breathe

Simple Power Query M to Display When the Report was Last Refreshed

Published on May 17, 2017 at 12:39AM

Very simple query to show when you last hit the 'Refresh' button in PowerBI

VBA for Last Saved At Timestamp with Hours Minutes and Seconds Ago

Published on May 04, 2017 at 06:50AM

Useful to have as a button or invoke overtime to alert when you have forgotten to save

Display a SQL Server Table Schema in PowerBI

Published on May 03, 2017 at 04:33AM

This was useful when building a subsequent M Query and needed to know all available table column, types and keys

Use a Table Column as a List in a Validation List

Published on April 18, 2017 at 07:07AM

This is easy to do but not as easy as you would first think.