Here comes some long awaited comfort functions for part 2 of my easy P&L series, where you don't have to define the single accounts any more.

There are three options:   There are two ways to write a measure that returns the most recent date / processing date in your data model.   1. If you have a data(transaction) table Most Recent Transaction = CALCULATE( MAX(Transactions[Date]), ALL(Transactions) ) 2. If you have a calendar table - ther...

by Matt Allington In this post, I am going to show you how simple it is to create a custom calendar using Power Query.  If you follow the steps below, you

If you want to collect your regularly loaded data without overwriting it or create a load log that writes the load activites with a

I don’t normally blog about Excel topics outside of Power Query and Power Pivot, but I think anyone who has ever done any serious work in Excel has found how difficult it is to concatenate more tha…

This post solves a tricky issue of removing offset duplicates or, in other words, removing items from a list that exist not only in a different column, but also on different rows. Problem History This data format is based on … Continue reading →