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
Favourite Photos

Looking over her shoulder (By Tamara Lichtenstein)

Categories
Favourite Photos

In the woods (By Tamara Lichtenstein)

Categories
Favourite Photos

Two in the lake (by Lars Wästfelt)