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
Author: Jacob
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
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
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: