Using Month as a Dimension on Multiple Date Fields

[salleninsd]

Hello all,

I am wondering if there is a way to make Month-Year as a free-standing dimension that I can use in timeline charts, where the dates are not connected to a Master Calendar.  I have multiple date values in different tables, and only a few are linked.  For example:

StartOfCare Date and ReferralDate are in the same table.  Conversion Rate is StartOfCare/ReferralDate.  Referral dates and start dates can be in different months, especially at the beginning and ending of the month.

I tried to make a month Dimension on an unlinked Master Calendar, but that didn't work .

Any suggestions?  Thanks in advance for any feedback!

[OmarBenSalem]

While ur aim is not clear enough; but try to take a look at this, maybe it will help :

Canonical Date

[salleninsd]

Thank you, Omar.  I will experiment with this to see if I can get it to work.

I appreciate your help!

[robert99]

Hi

I like canonical dates and use them a lot

But if you want to use an unlinked calendar

Try using P

ReferralDate= P (MasterCalendarDate)

example

Sum({<InvDate = P (DateMaster) , Year = , Month  , Day =  ,  YearFin , MonthFin , WeekEnding >}

InvLRev)