Multiple calendar Types in the same Master Calendar Table

[bruno_m_santos]

Hello to everybody.

I’ve created a new discussion because the old one had problems.

I have a question. What is the difference between the following two expressions? I thought in my "inexperience" that the values ​​should be equal but they are not.

I need your help to understand what is happening.

Expression1

  =Sum({$<MonthID = {"<=$(=Max(MonthID))"},

  CalendarType={"Fiscal"},

  Date = {"<=$(=Max(Date))"},

  Year = {$(=Max(Year))},

Week = ,

  Quarter = ,

  Period = ,

  [Period (#)] = ,

  Month = >}[#Turnover EUR])

Expression2:

  =Sum({$<MonthID = {"<=$(=Max(MonthID))"},

  Date = {"<=$(=Max(Date))"},

  Year = {$(=Max(Year))},

  Week = ,

  Quarter = ,

  Period = ,

  [Period (#)] = ,

  Month = >*<CalendarType={"Fiscal"}>}[#Turnover EUR])

The use of the "*" in the second expression intends to intersect with the lines of the "calendar table", in which CalendarType= "Fiscal".

My first expression doesn't return the correct data, because the Max(MonthID) for same year in calendartype="Fiscal" isn't same of other calendar type (eg:
Gregorian).

I've three calendars in the same table, with a identifier which is CalendarType.

My intention is to pass the calendar type as an variable, but for now i'm only testing values.

I 'll apreciate very much your help.

Bruno