Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
While ur aim is not clear enough; but try to take a look at this, maybe it will help :
Thank you, Omar. I will experiment with this to see if I can get it to work.
I appreciate your help!
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)