Struggling with a measure to calculate global projections using unique regional calendars

[jlichten]

Hello All,

I am struggling to develop a PowerPivot measure that can project global MTD and/or YTD figures based on sales in different areas of the world. I have no issues with the measure assuming the globe runs on the same calendar, but I am running into challenges having the calculation be dynamic using multiple unique work schedules.

My calendar table includes a column for each unique business calendar and my sales data is linked with each specific region but I am having trouble developing a dynamic formula.

Thanks in advance for any assistance or suggestions!

Thanks,
Josh

 

[scottsen]

Sounds pretty tricky! Would definately require more detail here, but... probably the workbook.

 

[jlichten]

Hi Scott,

Thank you for the reply. The workbook I am currently using contains sensitive information--I will come up with a demo workbook that contains the same information and post back when I can!

Thanks,
Josh