Categories
Code

Basic Power BI DAX Measures

Organising your model

Below are standard measures to use in your Power BI to do useful things like compute Month-on-Month or Year-on-Year calculations for any kind of metric.

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.