Date table question

[joe321]

I am working on doing analysis for expense reports. Each record has a date of the expense transaction. If the region is US, Canada or North America, I need use use a Jan 1- Dec 31 Fiscal Year. If the region is Europe, the fiscal year is Dec 1 to Nov 30.

An entry in the US on Dec 1, 2014 would fall into year 2014 and 4Q-2014. A European entry on Dec 1 2014 would fall into year 2015 and be Q1 2015.

I've been able do QTR vs prior QTR last year, YOY, and other time comparisons in PP, but this is a new wrinkle.

Can somebody give me general guidelines on how to set this up. Thanks in advance.

 

[SimonNU]

Can you elaborate on what the problem is exactly?

If the problem is the dual calendars - you add the required EU fiscal date columns (QTR in your case?) to your existing date table and then use some time intelligence functions over at Time Patterns – Dax Patterns