Categories
Code

How to ingest Excel or (zipped!) CSV files properly in Power Query for Power BI or Excel

When you import Excel or CSV (Comma Seperated Value) files in Power BI using the standard buttons, you end up with a large mess of code! Power BI creates a parameter, a sample file and an extra query…for every import!

Categories
Code

Power Query Ultimate Date Table for Power BI

You need a date table. It needs to give you day/week/month/quarter/half year visibility, and be able to adapt to whenever your fiscal year starts.

Categories
Recipes

Pizza on a BBQ (or oven)

How do you make pizza on a BBQ? You just make pizza on a BBQ! All you need is a BBQ and a metal plate to lay the pizza on. Item list:

Categories
Recipes

BBQ Cinnamon Pineapple Recipe

Grilled pineapple dusted with cinnamon is a super easy & delicious desert, which will light up any BBQ!

Categories
Recipes

Firecracker Salmon Recipe (Singapore BBQ Edition)

Firecracker salmon is super easy to make and is always a hit at any gathering. It can be served however you like – in its tin foil wrapper or even on a pizza!

Categories
Recipes

Walnut Brownies Recipe

This recipe for walnut brownies was first published in the “Lil’ Chefs” calendar by Unicef.

Categories
Code Web

CSS3 @font-face browser support table

It’s time for a CSS3 @font-face browser support table. One that documents specifically how browsers act when either the whole font family is specified (regular, italic, bold, bold-italic & small-caps) or only the regular version of the font is specified. The test-case that this based on uses the ideal, easiest (laziest) implementation and can be found on its own page here.

Categories
Linkblog

Best blogs of 2009

Hi Internet! Happy New Year! Here’s a list of the best weblogs on the internet in 2009:

Categories
Code

Vertically centring in css (without hacks and multi-line enabled)

Chris Coyier over at css-tricks.com had a great example of a css conundrum: how to centre, both vertically and horizontally, multiple lines of text. He some good code (using table-cell) but his code for IE relied on some (script)expressions which can have the unfortunate habbit of slowing down a page.

Categories
Code

CSS3 Fonts: The ideal implementation

This series of articles is about the challenges that arise when using @font-face. Font licensing is one (that many others have written about) and the file-size of included font-files is another, but this article is about browser implementation eccentricities. I’ll start off by showing the ideal @font-face implementation in this article, before moving on to showing current browser deficiencies and the implementation I settled on for including a full font-family which works in the here and now.