PowerPivot: Counting active days

Browsing on the web I have seen an interesting question that is worth a post, since I think it is a very common pattern and a good example of "thinking in DAX".

Starting from a table which contains a people and two dates (ActiveFrom, ActiveTo), we want to compute how many days an individual has been active over some period of time, let us say at the month level.